Forum Discussion
Danny-Happy
Helper I
Helper IAge 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 thanks!
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.
5 Replies
lukiz84Memorable Member
Age = VAR SelectedDate = SELECTEDVALUE(DateTable[Date]) VAR SelectedDOB = SELECTEDVALUE(Employees[DOB]) RETURN DATEDIFF(SelectedDOB, SelectedDate, YEAR)
Danny-HappyWhen i use the measure i don't get a response, see image
- lukiz84
please show your model and some sample data
- Danny-Happy
- lukiz84
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.