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
The ability to rank things is a very common requirement Finding the best customers computing the ranking position of products or detecting the countries with the best sales volumes are among the questions most frequently asked by management Ranking can… 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