Power QueryExercises

Build a calendar from the first to the last order date (bakery)

Create a table with one row for every day from the earliest to the latest order date, including days with no orders.

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

About this exercise

What you'll practise

Use list functions and let variables to generate a table instead of transforming one.

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

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

Expected output columns

Date (date)