Power QueryExercises

Predict which rows Fill Down will change (menu)

Before filling Group down, list the rows that will receive a value, and leave out rows Fill Down can't fill.

Level
intermediate
Time
~8 min
Task
Predict a step's result
Access
Pro
Checking your access…

About this exercise

What you'll practise

Predict Fill Down exactly, including the leading rows that stay null.

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

  • Sheet (table)
    • Group: text (nullable)
    • Item: text
    • Qty: number

Expected output columns

Item (text), Group (text)