Shared walkthrough

Explain my measure

An interactive SQLBI-style walkthrough of the measure below. The full diagrams — pills, row context, context transition, filter modification — render in the interactive view.

Open interactive walkthrough → Explain your own measure

The measure

What this walkthrough explains

Year-over-Year Sales Growth % =
DIVIDE(SUM(Sales[Sales Amount]) - CALCULATE(SUM(Sales[Sales Amount]), SAMEPERIODLASTYEAR('Date'[Date])), CALCULATE(SUM(Sales[Sales Amount]), SAMEPERIODLASTYEAR('Date'[Date]))) * 100

Walkthrough covers

The SQLBI concepts in this measure

✓Starting context ·Row context ·Context transition ✓Filter modification ✓Aggregation ✓Recap

See the full diagrams in the interactive view.

Hand-drawn marker pills, the row-context-to-filter-context disassembly, red X over removed filters — all the SQLBI visual language, applied to this measure.

Open interactive walkthrough →