Power QueryExercises

Convert day-first dates with the right locale (consultancy)

Claim dates are written 05/03/2026 meaning 5 March. Convert them to real dates using the en-GB culture.

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

Use a culture when converting text to dates so day and month aren't swapped.

Brightline Advisory (fictional) reimburses consultants' expenses. Finance exports claims monthly from the expense tool.

Steps

  1. Use the first row as headers.
  2. ClaimDate is written day/month/year. Convert it to a date using the en-GB culture.
  3. Set Amount to a decimal number.
  4. Keep only ClaimID, ClaimDate and Amount.

Your result must

  • ClaimDate is a date type
  • 05/03/2026 becomes 5 March 2026, not 3 May
  • Columns: ClaimID, ClaimDate, Amount

Input

  • ClaimsFile (file)
    • Text file; first line: ClaimID,Employee,ClaimDate,Amount
    • Every field is text until you set types

Expected output columns

ClaimID (text), ClaimDate (date), Amount (number)

First 3 of 10 expected rows
ClaimIDClaimDateAmount
C-00012026-05-27383.69
C-00022026-06-28111.09
C-00032026-01-22285.99