Power QueryExercises

Fix a query whose steps point at the wrong step (kite shop)

A step was renamed and the next step still refers to the old name. Repair the chain so the query runs.

Level
beginner
Time
~7 min
Task
Build the query
Access
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

Understand that each applied step names the previous step, and repair a broken reference.

Northwind Kites sells kites and accessories through three regional stores. Orders are exported from the till system every week.

Steps

  1. The starter query fails: the Added Revenue step refers to a step name that no longer exists.
  2. Fix the reference so the query keeps completed orders and adds Revenue = Qty × UnitPrice.
  3. Don't change what the query does, only make it run.

Your result must

  • The query runs without errors
  • Only Complete orders
  • Revenue column added

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), Region (text), Product (text), Qty (number), UnitPrice (number), OrderDate (text), Status (text), Revenue (number)

First 3 of 6 expected rows
OrderIDCustomerRegionProductQtyUnitPriceOrderDateStatusRevenue
0001Lena OkaforSouthBox Kite738.572026-06-07Complete269.99
0004Omar CastilloSouthDelta Kite151.982026-06-27Complete51.98
0006Sven DuarteSouthStunt Kite451.542026-05-22Complete206.16