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

article

Power BI is a model-based tool

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

article

Highlighting the minimum and maximum values in a Power BI matrix

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

article

Handling customers with the same name in Power BI

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

article

Using USERELATIONSHIP in DAX

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

article

Using calculation groups to switch between dates

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