Power QueryExercises

Fill region labels down a printed report (franchise)

The region is printed once per block. Fill it down so every store row has its region.

Level
beginner
Time
~6 min
Task
Build the query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Use Fill Down to repair report-style grouping labels.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • Report (table)
    • Region: text (nullable)
    • Store: text
    • Sales: number

Expected output columns

Region (text), Store (text), Sales (number)