Show % Employee Turnover - by month, with option to see by department, location, company

[Anonymous]

Hi,

I'm pretty new to PowerBI and need help setting up an employee turnover dashboard for HR. 

Requirements are to be able to see employee headcount history to date and employee turnover by: location, department and company. 

My table data is set out as follows:

Employee ID | Full Name | Company | Department | Location | Job Role | Type | Date | Staff

Type = Entry / Exit to inform the Date column

Staff = 1 for each employee

Please could some please help advise the best way i could add an additional turnover column to this table (below) as a %. The usual calculation used in HR is: Total leavers / average employees in that time period.

Many thanks!

[harshnathani]

@Anonymous ,

Please see if the below link works for you.

https://finance-bi.com/power-bi-employee-turnover-rate/

Regards,

Harsh Nathani

[Anonymous]

Thank you, this looks like what i'm looking for. I will have a go!

Thanks for your help.

[harshnathani]

@Anonymous ,

Great. Do let me know if it was useful.

Cheers,

Harsh Nathani

Did I help you ? Mark my post as a solution!

Appreciate with a Kudos!!

[Anonymous]

@harshnathani 

Hi, i've had a go and the measures do work but the table data that is coming through on the report tab is incorrect.

I'm wondering if it is going back to the relationship, as there are 2 date fields in one table and only one of the date fields can link to the calendar table? Please can you advise?

Thanks,

Harriet

[harshnathani · Accepted solution]

@Anonymous ,

Please see the below video.

Incase you need to use a different date which is not connect through a realtionship, you can use USERELATIONSHIP formula.

https://www.youtube.com/watch?v=sONvctPlplY

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

Thanks and Regards,

Harsh Nathani