Amsterdam, NLIntroducing window functions in DAX
Marco Russo & Alberto FerrariIn 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
SQLBI+ updates in January 2023
Marco RussoAfter 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
Mar 21-23 - Dallas
Apr 17-19 - Copenhagen
Video Training
Introducing DAX Video CourseFree
Windows Functions in DAX
Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. Read more
Debugging DAX measures in Power BI
This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Read more
DAX Patterns
Comparing different time periods
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
SQLBI Corp.
DAX Patterns, Second Edition
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