This article shows how to add an additional “other” row to the selection obtained using the Top N filter in a Power BI report.  Read more

This article describes what weak relationships are and the differences between strong and weak relationship in Power BI and DAX.  Read more

This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years.  Read more

This article describes how to create a slicer showing the values of multiple columns, applying the filter on any of the underlying columns.  Read more

This article describes different techniques to display the first three products for each category in Power BI. It includes considerations on how to adapt the technique to different models and requirements.  Read more

This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure.  Read more

The June 2019 update of Power BI includes the ability to filter slicer items based on a measure. This article explains why this is an important feature that should replace bidirectional filters used for the same purpose.  Read more

This article describes how to import into DAX Studio the performance metrics that can be exported by the Power BI Performance Analyzer, simplifying the analysis of slower queries in a report.  Read more

This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports.  Read more

The second edition of the Mastering DAX video course is available!  Read more