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
