topic Re: Show % Employee Turnover - by month, with option to see by department, location, company in DAX Commands and Tips

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

Anonymous — Thu, 14 May 2020 07:15:21 GMT

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:

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!

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

Anonymous — Thu, 14 May 2020 10:23:41 GMT

Anonymous ,

Please see if the below link works for you.

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

Regards,

Harsh Nathani

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

Anonymous — Thu, 14 May 2020 15:24:26 GMT

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

Thanks for your help.

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

Anonymous — Thu, 14 May 2020 18:41:29 GMT

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!!

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

Anonymous — Fri, 15 May 2020 12:39:49 GMT

Anonymous

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

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

Anonymous — Fri, 15 May 2020 12:46:50 GMT

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