Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Averaging per period. To average per month, iterate over the months in view with VALUES and let each one work out the measure. The number of months then follows the filters on its own: pick a quarter and only its months are averaged.
Avg Daily Orders = AVERAGEX(VALUES('Date'[Date]), [Orders])Regional managers plan staffing around a typical month. They want each region's average monthly revenue, and the figure must still be right when someone picks a single quarter in a slicer.
Write the measure Avg Monthly Revenue on order_items: the average of [Revenue] over the months in view. Iterate over the month numbers of the date table. The matrix shows it by region for 2025, next to [Revenue].
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