-
This article presents different techniques to compute a rownumber column in DAX based on a specific ranking, comparing slow and optimized approaches. Read more
-
This article describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub-expression. Read more
-
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
-
This article shows techniques to obtain a ranking based on more than one column. The ranking can be both static and dynamic. Read more
-
This article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition. Read more
-
This article describes how to analyze the performance of a DAX measure based on a DISTINCTCOUNT calculation and how to evaluate possible optimizations. Read more
-
In PowerPivot for Excel 2010 it is possible to import an Excel table in a PowerPivot data model by using the Linked Table feature. Excel 2013 expands this capability by Read more
-
The DIVIDE function in DAX is usually faster to avoid division-by-zero errors than the simple division operator. However, there are exceptions to this rule, described in this article through a simple performance analysis. Read more
-
The new DAX available in Excel 2016 and the data model in Power BI and Analysis Services 2016 offer tools to manage many-to-many relationships in a more efficient way than previous version, as described in this article. Read more
-
This article explains how to create a calculated column in DAX to get a sequential number identifying the events related to a particular entity. Read more