Average monthly sales
This matrix is sliced to 2025. The average monthly sales of a customer is the average over the months in which they bought: AVERAGEX(VALUES(Date[Month]), [Sales Amount]).
Dividing by 12 gives the average per calendar month instead, which is lower for customers who don’t buy every month. AVERAGEX skips the BLANK months.
Your task
Write Avg Monthly Sales: the average Sales Amount per month with sales, for each customer.
About this exercise
You practise iterating months with a measure with AVERAGEX and VALUES. The exercise runs on a small bike-shop model with a Sales fact table and Product, Customer and Date dimensions, the same star schema in every lesson.
Your measure, Avg Monthly Sales, fills a Power BI-style matrix grouped by Customer[Customer]. As in a real report, each cell evaluates the measure in its own filter context, and the subtotals and the grand total are evaluated again in theirs rather than added up. When you check your answer, every cell is compared with the expected value, wrong cells are marked, and the hint is about the mistake you made.
Measures that already exist in the model: Sales Amount. Reference them in square brackets, for example [Sales Amount].
Where you start
Avg Monthly Sales =The result to build
Slicer: Year is 2025
| Customer | Avg Monthly Sales |
|---|---|
| Anna Berger | 425.67 |
| Cycles Marchand | 1,706.34 |
| Emma Clarke | 1,200.00 |
| Fietsen De Vries | 2,328.61 |
| Jonas Weber | 965.17 |
| Léa Moreau | 552.43 |
| Northside Bikes | 1,792.23 |
| Oliver Hughes | 730.50 |
| Sanne Bakker | 84.43 |
| Velo Haus | 3,467.35 |
| Total | 10,811.36 |
Last updated 10 November 2026
Opening the exercise…