-
The blank value in DAX is a special value requiring particular attention in comparisons. It is not like the special null value in SQL, and it could appear in any conversion from a table expression. This article explores in details… 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
-
Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. 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
-
DAX creates a blank row to guarantee that results are accurate even if a regular relationship is invalid. The blank row is not created for limited relationships. This article shows the effect of not having a blank row in your… 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
-
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
-
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