-
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
-
This article explains the distinction between model-dependent and model-independent DAX user-defined functions, highlighting how dependencies impact portability and maintenance, and provides guidance on avoiding hidden dependencies and adopting proper naming conventions. Read more
-
This article introduces the new calendar-based time intelligence functions in DAX, available in preview from the September 2025 release of Power BI. Read more
-
In this article, we examine the details of executing DAX code, with a focus on how the IF function is implemented in various scenarios. Read more
-
This article describes how to control the execution of DAX code when there are either multiple or empty selections of calculation items in calculation groups. Read more
-
This article explains why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix. Read more
-
This article describes how to implement a dynamic Pareto calculation in Power BI based on a measure that can be selected from a slicer and dynamically filtered by other slicers in the report. Read more
-
Visual calculations are useful for performing calculations specific to a visual. Conditional formatting is a great example of this concept. In this article, we show how to easily implement conditional formatting through visual calculations. Read more
-
This article describes an Accounts Receivable Aging report in Power BI, and shows how to simplify a business problem using existing modeling patterns. Read more
-
This article describes the differences between the ALL and CROSSFILTERED functions in DAX. Read more