Calculating Employee Anniversaries

[BrianJ]

@DaveC,

OK, as I was posting above @uriah1977 already posted a solution, proving my point about how easy you made it to provide support…

Here are some other forum posts addressing similar issues that you may also find helpful:

Total Years of Service of Employees in the department

After I posted the above, I created the following columns which works close (for now) 1. Orig Hire Date 1 = DATEVALUE('Table'[Orig Hire Date]) 2. Today = Today() 3. Calculated Measure Diff2 = [Today].[Year] - [Orig Hire Date 1].[Year] The above works BUT Sum of DIFF2 gives additional years of service because it calculates those less than a year of service as 1. The correct answer should be 305 but Sum DIFF2 gives 339. Any ideas of refinement from the above DAX is appreciated.

Calculating age when date filter changes

Hi everyone, 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 cha…

• Brian