Power QueryExercises

Fix a query that removes a column before using it (bakery)

The query trims columns too early, so the Revenue step can't find UnitPrice. Reorder the steps.

Level
intermediate
Time
~7 min
Task
Fix a broken query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Read an Expression.Error about a missing column and fix the step order that caused it.

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

  • Orders (table)
    • OrderID: text
    • Customer: text
    • Region: text
    • Product: text
    • Qty: number
    • UnitPrice: number
    • OrderDate: text
    • Status: text

Expected output columns

OrderID (text), Customer (text), Revenue (number)