Understanding Group By Columns in Power BI
This 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
This 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
This article compares two common techniques to filter time periods in DAX: calculation groups and many-to-many relationships. Read more
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
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
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
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