Power QueryExercises

Predict which orders a filter will drop, nulls included (kite shop)

Before a Qty ≥ 3 filter goes live, list exactly the orders it will remove, including the ones with no quantity.

Level
intermediate
Time
~8 min
Task
Predict a step's result
Access
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

Predict how comparisons with null behave in a row filter.

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

Steps

  1. Next week the step Table.SelectRows(Orders, each [Qty] >= 3) will be added to the report.
  2. Return the orders that step will drop: every row it does not keep. Some orders have a null Qty.
  3. Keep all columns.

Your result must

  • Orders with Qty below 3 are listed
  • Orders with a null Qty are listed too
  • No order with Qty ≥ 3

Input

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

Expected output columns

OrderID (text), Customer (text), Region (text), Product (text), Qty (number (some rows null)), UnitPrice (number), OrderDate (text), Status (text)

First 3 of 4 expected rows
OrderIDCustomerRegionProductQtyUnitPriceOrderDateStatus
0001Jun FofanaSouthBox Kitenull27.352026-01-05Pending
0007Sven GrieveEastReelnull8.462026-02-13Complete
0009Hana MensahNorthDelta Kite239.552026-05-16Pending