Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Ratios over a period. A ratio over a period accumulates both sides first and divides once: total earned so far over total planned so far. Averaging monthly ratios gives a different, wrong answer when months differ in size. CALCULATE(DIVIDE(a, b), DATESYTD('Date'[Date])) and DIVIDE(TOTALYTD(a, …), TOTALYTD(b, …)) both do it right.
Refund Share YTD = CALCULATE(DIVIDE(SUM(refunds[amount]), [Revenue]), DATESYTD('Date'[Date]))One weak month shouldn't alarm the board, so the CFO tracks attainment on a year-to-date basis: everything earned so far against everything planned so far.
Write the measure Attainment YTD on targets: Revenue year to date divided by Target year to date (1 means exactly on plan). Build the year to date on 'Date'[Date] and divide with DIVIDE. The matrix shows it by month of 2025.
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