Power QueryExercises

Remove a leftover step that cuts the data short (kite shop)

A Kept First Rows step left over from testing silently drops orders. Find it and remove it.

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

About this exercise

What you'll practise

Read the applied steps of a query and spot a step that only works for today's data.

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

Steps

  1. The query should return every order whose Status isn't Cancelled, sorted by OrderDate ascending and then OrderID ascending.
  2. Someone added a Kept First Rows step while testing. Remove it so no orders are lost, and keep the other steps.
  3. Keep all columns. Row order is graded.

Your result must

  • No Cancelled orders
  • Every other order is present
  • Sorted by OrderDate, then OrderID

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 7 expected rows
OrderIDCustomerRegionProductQtyUnitPriceOrderDateStatus
0008Lena MensahNorthDelta Kite659.692026-02-03Complete
0004Viktor DuarteNorthBox Kite940.752026-04-16Pending
0005Omar UddinSouthDelta Kite146.822026-04-17Complete