90 Day Employee Churn

[patrail]

Hello,

I am trying to calculate the employee churn for my company. The data set is simple (see here), the table is updated daily with the IDs of all active employees. If an employee is not in the previous day, they are new and if they are in the previous day and not in the most recent date then they left.

This seems straight forward but I am not sure how I would write a measure for this. The churn rate is defined as:

 total employees that left in a month / employees as the start of the month.

Any help is appreciated as I have been stuck on this for a while. Thanks!

[v-yanjiang-msft]

Hi @patrail ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[CNENFRNL]

The underlying logic of your question is fairly simple; if an employee existing during the month doesn't appear at the end of month, he/she must have left.