-
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
-
After the SQLBI+ launch in November 2022, we released the first update with additional content: two sessions about Time Intelligence and one whitepaper about the new DAX window functions. This is much more than the single Time Intelligence session we… Read more
-
Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. Read more
-
If you create server aliases for SQL Server connections, you should be aware of the changes introduced in SQL Server 2022. At SQLBI we use aliases to identify the server’s name in the connection of our sample files (Power BI… 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
-
Here we are, at the end of another year, to see what happened in the DAX world. 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
-
There are cases where the dictionary size reported by VertiPaq Analyzer (used by DAX Studio, Bravo for Power BI, and Tabular Editor 3) does not correspond to the actual memory required by the dictionary. However, the number reported is technically… Read more
-
The filter arguments in CALCULATE can be written as logical conditions with certain restrictions. This article explains the more common errors in these conditions and how to solve them. Read more