• Power BI Pro Tip: DIVIDE() function

    If you ever used Power Pivot to calculate things such as sales amount per capita or averages of some sort you will have run into the situation that the denominator (the column you want to divide by)…

  • Power BI learning resources – follow up

    For those of you that would like to get up to speed with Power BI but rather read a book, here are some suggestions: For Dutch readers: Praktijkboek PowerPivot in Excel DAX Formulas for PowerPivot by Rob…

  • Power BI Pro Tip: Role playing dimensions with UseRelationship

    One frequent need in BI is something called a role playing dimension (see http://en.wikipedia.org/wiki/Dimension_(data_warehouse)#Role-playing_dimension for a definition). The classic example of this is a Date dimension that is related to a Sales fact table and used either…

  • Power BI Pro Tip: Sort By Column

    Here is an easy solution to a very common problem when making reports: how do I change the sort of some items from alphabetically to something else? The most apparent sample of this is Months. Let’s say…

  • Power BI Demo Contest

    I want to draw your attention to a contest that we run: the Power BI Demo Contest. All you need to do is create a short video of something cool you built using Power BI and share…