Power QueryExercises

Filter with and/or conditions in the right grouping (kite shop)

Keep big orders from anywhere, plus non-cancelled orders from North or South. Parentheses matter.

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

About this exercise

What you'll practise

Combine and/or conditions with explicit grouping.

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

Steps

  1. Keep an order when either its Qty is 8 or more (any region, any status), or its Region is North or South and its Status isn't Cancelled.
  2. Keep all columns.

Your result must

  • Every order with Qty ≥ 8 kept
  • North/South orders kept unless cancelled
  • East orders under 8 dropped

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 5 expected rows
OrderIDCustomerRegionProductQtyUnitPriceOrderDateStatus
0002Yara TanakaNorthDelta Kite753.932026-03-25Complete
0003Jun ItoEastDelta Kite915.482026-02-21Cancelled
0005Dmitri ZielinskiNorthReel151.232026-04-08Complete