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...
davehus
Memorable Member
Memorable MemberHi Syndicate_Admin , If you are using a column then it won't work as the column is computed only at refresh. You could create a measure and use a combination of selectedvalue and and date diff below.
DATEDIFF(FIRSTNONBLANK('Age'[Date],1),SELECTEDVALUE('Date'[Date]),YEAR)
Did I help you today? Please accept my solution and hit the Kudos button.
Syndicate_AdminAdministrator
AdministratorBut in addition to calculating the age at any given time, I have to represent that age in a graph like this and I can not calculate only the age of 1 person, but that of the whole set: