Power QueryExercises

Project: build the weekly reorder list (hardware)

List the items below their reorder level with how many to order and the supplier's email, sorted for the buyer.

Level
intermediate
Time
~14 min
Task
Build the query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Combine filtering, a calculated column, a lookup merge and a multi-key sort into a usable report.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • Stock (table)
    • SKU: text
    • Item: text
    • Warehouse: text
    • OnHand: number
    • ReorderLevel: number
    • Supplier: text
    • UnitCost: number
  • Suppliers (table)
    • Supplier: text
    • Email: text

Expected output columns

Supplier (text), Email (text), SKU (text), Item (text), Order Qty (number)