Power QueryExercises

Keep only completed orders (kite shop)

Filter out cancelled and pending orders so only completed sales remain.

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

About this exercise

What you'll practise

Filter rows on an exact text value with a repeatable condition.

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

Steps

  1. Keep rows where Status equals Complete.
  2. Keep all columns.

Your result must

  • Only Complete orders remain
  • All columns kept
  • Works on next week's export

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 6 expected rows
OrderIDCustomerRegionProductQtyUnitPriceOrderDateStatus
0001Zane KowalEastTail Ribbon542.162026-05-07Complete
0002Rosa GrieveEastReel66.012026-02-16Complete
0005Wen ZielinskiSouthReel93.422026-04-01Complete