Age based on selected date

[Danny-Happy]

Hi All,

I want to see the age of our employees on a chosen date in a filter(so not today).
I got a table with employee name an DOB and a calender table.
Which measure should I use?

Many thanks!

[lukiz84]

please show your model and some sample data

[Danny-Happy]

Sample.pbix

[lukiz84 · Accepted solution]

thx, you have to remove the relationship between Date and DOB. Otherwise Date filters Employee and shows only the people that had a birthday ON THE SELECTED DATE.

[Danny-Happy]

When i use the measure i don't get a response, see image

[lukiz84]

Age =
VAR SelectedDate = SELECTEDVALUE(DateTable[Date])
VAR SelectedDOB = SELECTEDVALUE(Employees[DOB])

RETURN DATEDIFF(SelectedDOB, SelectedDate, YEAR)