How to Use the RELATED Function in DAX: Step by Step
Learn how to use the RELATED function in DAX to pull values from a related table into another, with a practical sales-a…
4 min
15 Jul 2026
How to Calculate Percentage of Total in DAX: Step by Step
Learn how to calculate the percentage of total in DAX using DIVIDE, CALCULATE and ALL. A step-by-step guide with exampl…
4 min
10 Jul 2026
How to use the SWITCH function in DAX: step by step
Learn how to use the SWITCH function in DAX step by step: map values, build tiers with SWITCH(TRUE()) and replace neste…
4 min
08 Jul 2026
How to use DIVIDE in DAX to avoid division by zero
Learn how to use the DIVIDE function in DAX to calculate ratios without division-by-zero errors, with a practical margi…
4 min
06 Jul 2026
How to create a ranking with RANKX in DAX: step by step
Learn how to build a dynamic ranking with the RANKX function in DAX. A step-by-step example in Power BI, covering ALL, …
4 min
05 Jul 2026
How to create a running total in DAX: step by step
Learn how to create a running total in DAX using CALCULATE and FILTER. A step-by-step guide with a practical example fo…
4 min
04 Jul 2026
DAX patterns: running totals, YoY and moving averages
Three recurring DAX patterns in business analysis: running totals, year-over-year comparisons and moving averages. Lear…
1 min
13 Feb 2026
Variables in DAX: more readable and faster measures
Using variables with VAR/RETURN is one of the most impactful improvements you can make to your DAX code, boosting reada…
2 min
19 Sep 2025
Time Intelligence in DAX with a custom date table
DAX Time Intelligence functions require a marked date table. Learn to build a robust table and use YTD, MTD and year-ov…
1 min
28 Apr 2025
CALCULATE in DAX: the engine behind every advanced measure
CALCULATE is the most important DAX function. Learn how it modifies the filter context and why it underpins almost ever…
2 min
03 Dec 2024
Row context vs. filter context in DAX: the essential distinction
Confusion between row context and filter context is the source of 90% of DAX errors. Understand the difference with pra…
2 min
10 Jul 2024