This article describes how to implement in DAX a logical OR condition between the selection of two slicers of a Power BI report or of a PivotTable in Excel. By default, when relying on more than one slicer they are… Read more
Expanded tables are the core of DAX; understanding how they work is of paramount importance. This article provides a theoretical foundation of what expanded tables are, along with fundamental concepts useful when reading DAX code. Read more
This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand performance issues, and to improve the writing of DAX queries. Read more
This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might display unexpected behaviors. Read more
The dynamic version of the ABC Classification pattern is an extension of the Dynamic Segmentation pattern It groups items such as Products or Customers into segments based on their cumulated sales and how much they contributed to the total sales… www.sqlbi.com
How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. Read more
Jun 26-28 - Amsterdam
Aug 7-9 - Sydney
May 15-17 - Atlanta
May 16-18 - London