Employee turnover

Hi Anonymous,

Thank you for your answer.

I added a tab with the desired output in the example.

For example employee 9236064:

Exists for the first time on 2019-04-20, so starting at Company, Region, Team and Unit in the month april.

On may 31th this employee moves to another Unit and Team but within the same Region. So in may this employee will be counted as a leaver for the Team 20030 and Unit 23803. This employee will be counted as a starter in june for the Team 20310 and Unit 20044. On Region and Company level there are no changes for this employee. Exists for the last time on 2019-08-10, so starting at Company, Region, Team and Unit in the month april.

Probably I am searching for an DAX query which counts on Unit, Employee and Date level whether a row exists a day earlier or later.

I hope my question is more clear.

Luuk