Power QueryExercises

Filter orders to a date window from a parameter table (kite shop)

A one-row Settings table holds StartDate and EndDate. Keep orders inside that window, both ends included.

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

Filter with values read from another query instead of typed constants.

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

Steps

  1. Settings has one row with StartDate and EndDate (dates).
  2. Convert OrderDate to a date, then keep orders on or after StartDate and on or before EndDate.
  3. Keep all columns. Don't type any dates into the query.

Your result must

  • Orders on StartDate and on EndDate are kept
  • Nothing outside the window
  • Changing Settings changes the result

Input

  • Orders (table)
    • OrderID: text
    • Customer: text
    • Region: text
    • Product: text
    • Qty: number
    • UnitPrice: number
    • OrderDate: text
    • Status: text
  • Settings (table)
    • StartDate: date
    • EndDate: date

Expected output columns

OrderID (text), Customer (text), Region (text), Product (text), Qty (number), UnitPrice (number), OrderDate (date), Status (text)

First 2 of 2 expected rows
OrderIDCustomerRegionProductQtyUnitPriceOrderDateStatus
0003Sven SilvaSouthReel74.262026-01-10Complete
0004Bao QuistNorthDelta Kite97.712026-01-02Cancelled