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
Standard time-related calculations
In this pattern we show you how to compute time-related calculations like year-to-date same period last year and percentage growth using a standard calendar The great advantage of working with a standard calendar is that you can rely on several… 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