-
Ranking is useful and, in our book, I and Marco provide a lot of information about how to perform ranking with PowerPivot. Nevertheless, there is an interesting scenario where ranking can be performed without complex DAX formulas, but with just… Read more
-
In case you missed it, this post from Jeffrey about DAX and the way filter contexts work is simply awesome! The way he explains the filter contexts internals is great, deep technical and yet easy to understand. Very very strongly… Read more
-
This article describes the differences between report-based tools and model-based tools. Because Power BI is a model-based tool and not a report-based tool, it is useful to have a quick reference guide explaining these differences. Read more
-
This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI. Read more
-
This article explains how to show different customers with the same name in a Power BI report by using zero-width spaces, thus simplifying the presentation without adding visible characters to make the names unique. Read more
-
This article shows how to use the USERELATIONSHIP function in DAX to change the active relationship in a CALCULATE function. Read more
-
Something really big is happening! The July 2020 version of Power BI Desktop allows you to create calculation groups in Power BI Desktop, thanks to the new “external tools” feature that enables the integration with Tabular Editor. We had been… Read more
-
Less than a month ago, Microsoft introduced the External Tools feature in the Power BI Desktop July 2020 release. By using DAX Studio, you were already able to create a PivotTable in Excel connected to the model hosted by Power… Read more
-
We all have biases. Personally, I kick myself whenever I identify that I have applied my biases when doing an evaluation of any kind. Unfortunately, this happens often because I work with numbers every day. Do you think we at… Read more
-
This article shows how to use calculation groups to change the active relationship in a model in order to let users choose among multiple dates. Read more