Power QueryExercises

Replace a hand-typed list of IDs with a rule (kite shop)

The query removes cancelled orders by listing this week's cancelled OrderIDs. Make it work every week.

Level
intermediate
Time
~6 min
Task
Fix a broken query
Access
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

Recognise steps that only work for today's data and replace them with a rule based on the data.

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

Steps

  1. The starter removes this week's cancelled orders by typing their OrderIDs into the filter.
  2. Rewrite the filter so it removes every order whose Status is Cancelled, whatever its ID.
  3. Keep all columns and all other orders (Complete and Pending).

Your result must

  • No Cancelled orders
  • Complete and Pending orders kept
  • No OrderIDs typed into the query

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)

First 3 of 9 expected rows
OrderIDCustomerRegionProductQtyUnitPriceOrderDateStatus
0001Sven SilvaEastBox Kite954.952026-03-01Pending
0002Mateo QuistNorthStunt Kite148.632026-05-19Complete
0004Omar UddinSouthStunt Kite67.982026-04-09Pending