I have a list of employees and a date slicer on my report (Date From & Date To). When I change the “Date To” I need to calculate the following:
- The age of each employees relative to the “Date To”, for example: “Date To” - BirthDate
- The no. of years of service for each employee, relative to the “Date To”, for example, “Date To” - “Date Joined”
- The Years of Service Grouping for each employee, relative to the “Date To” e.g. 1-5, 6-10, etc.
The problem I’m having is that, when I change the “Date To” in the date slicer, the Age and Years of Service do not change.
What would be the best way to iterate through the Employees table and update the above 3 elements please?
Thanks in advance.