Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
A ratio over a moving window. CALCULATE evaluates its first argument, a whole expression, under the new filters. So CALCULATE(DIVIDE(a, b), window) applies the window to both measures at once. Targets are stored on the first day of each month, and a three-month DATESINPERIOD window always contains exactly three of those days.
Units per Order 3M = CALCULATE(DIVIDE([Units], [Orders]), DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -3, MONTH))Daniel Ortiz runs West and reviews his region against target every month. Year to date hides recent changes and a single month is noisy, so he wants attainment over the latest three months.
Write the measure Attainment 3M on targets: Revenue divided by Target, both over the three months ending on the last day of the row's month. Use DATESINPERIOD on 'Date'[Date] and DIVIDE. The matrix shows it by month of 2025 with the region slicer on West.
Matrix
Updates as you typeFilters on this visual'Date'[Year] is 2025
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe