Power QueryExercises

Keep orders for a list of products (kite shop)

Keep only orders whose Product is in the promotion list held in a separate PromoProducts table.

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

About this exercise

What you'll practise

Filter against a list of values from another query with List.Contains.

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

Steps

  1. PromoProducts has one column, Product.
  2. Keep orders whose Product appears in that list.
  3. Keep all order columns.

Your result must

  • Only promotion products remain
  • Changing the promotion table changes the result
  • All columns kept

Input

  • Orders (table)
    • OrderID: text
    • Customer: text
    • Region: text
    • Product: text
    • Qty: number
    • UnitPrice: number
    • OrderDate: text
    • Status: text
  • PromoProducts (table)
    • Product: 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
0002Zane LindqvistNorthStunt Kite347.862026-06-14Cancelled
0004Esi HaddadSouthStunt Kite711.322026-03-22Pending
0006Hana ZielinskiSouthStunt Kite157.372026-03-04Cancelled