age at a set date in time

[maurcollins1]

Good morning

I need some help please with how to calculate someones age at a certain date in time.

I have the following fields

Academic Year 22/23

Date of Birth 03/05/1998

Course start date: this can be various points throughout the academic year for example 5th September 2022 or 7th January 2023

I need to show how old the person was at the 31st August for the academic year. so for academic year 22/23 it will be 31 august 2022.

i am currently using datediff: date of birth and datevalue 31/08.

This is working but i am aware that once we move to the new calendar year the year in the datevalue will change to 2023 and my calculation will be incorrect.

I cant use date(2022,08,31) as i would need to change the 2022 each year.

Any ideas please as i am new to power bi

[Anonymous]

Hi 

That has worked, thank you.

[amitchandak · Accepted solution]

@maurcollins1 , You can use date like

date(year(today()) ,08,31)

or

date(if(month(today()) >8, year(today()) , year(today())-1),8,31)