Power QueryExercises

Build a date from year, month and day columns (deliveries)

A legacy export stores dates as three number columns. Combine them into one real date.

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

About this exercise

What you'll practise

Construct typed date values from numeric parts with #date.

Crumb & Co. (fictional) reads delivery records from an old ordering system that stores dates as three numbers.

Steps

  1. Add Date = the date made from Year, Month and Day (a date value, not text).
  2. Output ID and Date.

Your result must

  • Date is a date value
  • Day 4 of month 3 is 4 March, not 3 April
  • Two columns

Input

  • Legacy (table)
    • ID: text
    • Year: number
    • Month: number
    • Day: number

Expected output columns

ID (text), Date (date)

First 3 of 7 expected rows
IDDate
DL-12025-05-09
DL-22026-01-03
DL-32026-09-06