Using EXPAND and COLLAPSE in visual calculations
This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result. Read more
This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result. Read more
What is the right choice between Direct Lake and Import mode in Power BI? Read more
This article describes how you can use a scatterplot visual to make more effective Power BI reports. Read more
We did it again! Yesterday, as an April Fool, we published an article written by ChatGPT-4 (Revolutionizing Power BI: Introducing the Ultimate Formula Language), which described better than I could have ever done the excitement for a new revolutionizing language:… Read more
This post introduces the four time-related calculations patterns presented in this website The goal here is to help you choose the right pattern based on your specific needs Indeed when it comes to time-related calculations the choice of the pattern… 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