Forum Discussion
Syndicate_Admin
Administrator
AdministratorAges according to dates
Good morning I need to calculate in a column, the ages that people had on the selected date. On the one hand I have the calendar where I mark the date I want, on the other I have the date of birt...
Hi Syndicate_Admin ,
Please refer to my pbix file to see if it helps you.
Create a measure on calendar table first.
Measure = MAX(Calendario[Date])Then create a column.
Column eccionada =
VAR _a = [Measure] RETURN DATEDIFF ( Demandas[fecha_nacimiento], _a, YEAR )
If I have misunderstood your meaning, please provide your desired output with more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_AdminAdministrator
AdministratorI have tried it but the data is not updated when the year changes and I want the ages to be updated again according to the selected year.