Forum Discussion
Solved
Age based on selected date
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 tha...
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.
Age =
VAR SelectedDate = SELECTEDVALUE(DateTable[Date])
VAR SelectedDOB = SELECTEDVALUE(Employees[DOB])
RETURN DATEDIFF(SelectedDOB, SelectedDate, YEAR)