Find Returning Employees

[JB_AT]

I hope you experts can help

I have an EmployeeHistory table with 3 main columns that i want to calculate on. It's a snapshot table, so there are many entries with the same information. 

• EmployeeID
• HireDate
• TermDate

The table has two dimension tables connected to it. Date and Employee. Both of these tables have a 1 to many relationship on the HireDate and EmployeeID and there is also a inactive relationship on the TermDate.

The TermDate is empty if they are still working for us.

I want to calculate when an employee returns to work at the company. This calculation shouldn't show the first HireDate.

Example Table: 

EmployeeID	HireDate	TermDate
1	01/01/2020	15/03/2021
1	01/01/2020	15/03/2021
1	01/01/2020	15/03/2021
1	19/11/2022
1	19/11/2022

Thanks

[lbendlin]

New and returning customers – DAX Patterns