DAX practice: Sequential Shifts & Moving Windows

Chapter 17 · 3 questions · included in full access

Question 1 · medium
Previous month
Write Sales PM: [Total Sales] for the prior month using PREVIOUSMONTH.
Solve it in your browser
Question 2 · medium
MoM sales delta
Write MoM Sales Delta: subtract prior month sales (PREVIOUSMONTH) from [Total Sales].
Solve it in your browser
Question 3 · hard
Rolling three months
Write Rolling 3M: [Total Sales] over the trailing 3-month window ending on the current date.
Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.