Skip to content
← Back to the guide

Common DAX patterns in Power BI

8slides. Screenshot a slide, download it as a PNG, or use your browser's Print → Save as PDF for a LinkedIn-ready multi-page carousel — each slide becomes one page.

M
solvingmicrosoft365.com
1 / 8

Common DAX patterns in Power BI

Useful DAX patterns for Power BI semantic models — time intelligence, ranking, period-over-period, what-ifs.

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/dax-patterns

Slide 1Download PNG
M
solvingmicrosoft365.com
2 / 8
01

Time intelligence

For most semantic models, time-based comparisons are the most-requested analytics. DAX time-intelligence functions (assuming you have a proper Date table marked as a date table):

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/dax-patterns

Slide 2Download PNG
M
solvingmicrosoft365.com
3 / 8
02

Period-over-period

Beyond simple YTD / YoY, arbitrary period comparison patterns:

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/dax-patterns

Slide 3Download PNG
M
solvingmicrosoft365.com
4 / 8
03

Ranking

Rank customers, products, regions by some measure:

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/dax-patterns

Slide 4Download PNG
M
solvingmicrosoft365.com
5 / 8
04

What-if scenarios

For interactive scenarios where the user picks a slider value:

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/dax-patterns

Slide 5Download PNG
M
solvingmicrosoft365.com
6 / 8
05

Iterating with X functions

The aggregator-X functions evaluate row-by-row:

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/dax-patterns

Slide 6Download PNG
M
solvingmicrosoft365.com
7 / 8
06

CALCULATE with multiple filters

CALCULATE is the central DAX function:

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/dax-patterns

Slide 7Download PNG
M
solvingmicrosoft365.com
8 / 8
07

Variables for clarity

Long DAX expressions get unreadable. Use VAR for clarity:

Solving Microsoft 365 · www.solvingmicrosoft365.com/guides/dax-patterns

Slide 8Download PNG

Auto-generated from Common DAX patterns in Power BI. This page is not indexed and isn't part of the guide itself.