Tracking Employees from Month to Month

Data Scenario –

We need to track employee movement from month to month. We are starting with a baseline file (Employee ID – Dec18) that has many employees; then we have monthly files (Employee ID – Jan19), etc. with employees for that month. Some employees might be terminated, and others can be new employees. When an employee is terminated in Jan19 we should not see them in Feb19. If a new employee is hired in Feb19 we should see them. 

Created -

We’ve built relationships between the files. The relationships we’ve created allows us to track terminated employees from month to month however, any new employees that are added to future months are not showing.

We created a table in Power BI that allows us to check for any new employees added to a future month.

(New Employees = EXCEPT('Feb18_EmployeeRoster','Jan18_EmployeeRoster')

We created a table visualization and pulled the “Employee ID” from baseline, then the monthly files Jan19, and Feb19.   

Issue –

When we add the “Employee ID” from the New Employees Table it does not allow us to see the newly added employees.  

If anyone can assist with a solution that allow us to track employee movement within the same visualization it would be greatly apricated!  Thank You!