We use cookies for analytics. Cookie policy.

Free Download

The Power BI
DAX cheat sheet

The patterns that actually ship — and the one setup tip nobody tells you. No 40-page PDF you'll never open. Just the things you reach for at 5pm when the report is due.

  • The #1 setup tip nobody tells you — parameterise your source
  • CALCULATE, filter context and time intelligence, decoded
  • Iterators, ranking and the patterns stakeholders actually ask for
  • 27 copy-paste snippets — printable, one click to PDF

Get the cheat sheet

Drop your email. The link lands instantly — and you'll hear when the next drop ships. Nothing in between.

No spam. Unsubscribe any time. Privacy policy.

What's inside

Signal, not 40 pages.

Curated to the patterns you actually use. One page on screen, one click to PDF.

No.01 · biggest tip

Parameterise your data source

Hard-code one file path and future-you pays for it every deployment. Parameterise once, change one value forever.

Foundations

The four things every measure you ever write is built from.

4 snippets

Filter context

Bending what the visual is allowed to see. Where DAX gets powerful.

5 snippets

Time intelligence

Needs a marked Date table. No exceptions, no shortcuts.

5 snippets

Iterators & ranking

Row-by-row maths, and putting things in order.

5 snippets

Logic, text & blanks

Branching, dynamic labels, and handling the empty cells gracefully.

4 snippets

Relationships

Reaching across tables — and bending the model when you must.

3 snippets