Employee Turnover

Frequent Visitor

8 years ago

Hey Lydia,

Thanks for the solution its works. But whan will be solution if the data is available in two seperate table one is of ACTIVE EMPLOYEE and the other one is of SEPARATED EMPOYEE and both are uploaded to data model then how we can calculate the same turnover by using the same formula. Below are the sample table for you reference.

Name Month Status

Alex	Jan	Active
Maria	Feb	Active
Maria	Feb	Active
Maria	Feb	Active
Sid	Feb	Active
Zahid	March	Active
Zoe	March	Active
Zeus	March	Active
Kahisf	April	Active
Kahisf	April	Active
Carol	April	Active
Martin	May	Active
Wick	May	Active
Ricku\y	May	Active
Rex	June	Active
Ted	June	Active
Juliana	Juy	Active
Julia	Juy	Active
Arman	August	Active
Arman	August	Active
Nancy	Sept	Active
Matthew	Sept	Active
Bela	Oct	Active
Betta	November	Active
Oliver	November	Active

Name Month Status

Siddiq	Jan	Separated
Sahid	Feb	Separated
John	Feb	Separated
Johny	March	Separated
Terry	April	Separated
Martin	May	Separated
Luther	June	Separated
Katherine	Juy	Separated
Williams	August	Separated
Bony	Sept	Separated
Bretta	Oct	Separated
Carla	November	Separated

Looking for a solution from you for making it dynamic.

Regards,

Muhammad Siddiq

Forum Discussion

Related content

Rolling 12-Month Employee Turnover

Employee Turnover

Incorrect turnover total

Employee Turnover and Retention Dax

Employee turnover monthy