Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Employee turnover

Hello,   I want to calculate the number of employees starting and leaving each month. Employees can start new at the company or starting at another region, team or unit within a company, same for ...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Well... actually, nothing's clear in this explanation of yours.

 

Best

Darek

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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