Analyzing the performance of limited and regular relationships
This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships. Read more
This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships. Read more
It is time for our annual review of what happened in the DAX and SQLBI worlds, and what we should expect in 2026! Read more
This article describes the data model and DAX measures to analyze the effectiveness of campaigns, by separating attributed sales (directly linked to a campaign) from influenced sales (all sales of products participating in campaigns, regardless of attribution). Read more
Three months ago, Microsoft introduced the User-Defined Functions (UDFs) in the DAX language. From the first day, https://daxlib.org has been available to share libraries of functions with the Power BI community. We published DAX Lib with a low profile because… Read more
The Transition matrix pattern analyzes changes in an attribute assigned to an entity at regular intervals For example customers might receive a ranking evaluation every month or products might have a rating score measured every week Measuring the changes in… More on DAX Patterns
The Definitive Guide to DAX is an authoritative resource for mastering the DAX language, which is pivotal for creating measures for semantic models in Microsoft Power BI, Fabric, Analysis Services, and Excel.
Read more