Introducing window functions in DAX
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
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
This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Read more
This pattern is a useful technique to compare the value of a measure in different time periods For example we can compare the sales of the last month against a user-defined period The two time periods might have a different… More on DAX Patterns
A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more