Topic: DAX
-
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. Read more
-
This article describes how to implement a DAX measure to run faster than what you get from the built-in fusion optimization. Read more
-
This article provides the best practice to use ADDCOLUMNS and SUMMARIZE, two functions that can be used in any DAX expression, including measures. Read more
-
This article describes how Power BI uses the Group By Columns attribute of a column and how you can leverage it in specific scenarios. Read more
-
Data lineage is such a well-implemented DAX feature that most developers use it without knowing about it. This article describes data lineage and how it can help in producing better DAX code. Read more
-
This article compares two common techniques to filter time periods in DAX: calculation groups and many-to-many relationships. Read more
-
In December 2022, DAX was enriched with window functions: INDEX, OFFSET, and WINDOW. This article introduces the syntax and the basic functionalities of these new features. Read more
-
This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Read more
-
Having read this question on the mdsn blogs, I investigated on the KEEPFILTERS function and, after having learned it, it is now time to write about it. Moreover, before start to write about it, I need to thank the dev team… Read more
-
This article explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool. Read more