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
Currency conversion
Currency conversion is a complex scenario where both the data model and the quality of the DAX code play an important role There are two kinds of currencies the currency used to collect orders and the currency used to produce… 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