topic Re: 90 Day Employee Churn in DAX Commands and Tips

90 Day Employee Churn

patrail — Tue, 26 Apr 2022 16:05:04 GMT

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!

Re: 90 Day Employee Churn

CNENFRNL — Tue, 26 Apr 2022 20:39:55 GMT

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.

Re: 90 Day Employee Churn

v-yanjiang-msft — Fri, 06 May 2022 06:16:25 GMT

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