Power QueryExercises

Calculate age in completed years on a report date (rowing club)

Work out each member's age on 30 June 2026, counting only birthdays that have already happened.

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

About this exercise

What you'll practise

Do exact calendar arithmetic instead of dividing days by 365.

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

  • Members (table)
    • MemberID: text
    • BirthDate: text

Expected output columns

MemberID (text), Age (number)