Power QueryExercises

Parse dates that arrive in two different formats (salon)

Bookings from the website use 2026-03-04; bookings from the phone team use 04/03/2026 (day first). Parse both correctly.

Level
advanced
Time
~10 min
Task
Build the query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Use try … otherwise to fall back between explicit date formats instead of relying on a culture guess.

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

  • Bookings (table)
    • BookingID: text
    • Raw: text

Expected output columns

BookingID (text), Booked (date)