Amsterdam, NLUnderstanding Group By Columns in Power BI
Marco Russo & Alberto FerrariThis 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
Using calculation groups or many-to-many relationships for time intelligence selection
This article compares two common techniques to filter time periods in DAX: calculation groups and many-to-many relationships. Read more
Apr 17-19 - Copenhagen
May 17-19 - Seattle
Jun 14-16 - Perth
Video Training
Introducing DAX Video CourseFree
Understanding blank row and limited relationships
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
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
DAX Patterns
Semi-additive calculations
Calculations reporting values at the start or the end of a time period are quite the challenge for any BI developer and DAX is no exception These measures are not hard to compute the complicated part is understanding the desired… 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