Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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.

 

Capture.PNG

 

Many thanks!

 
1 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

View solution in original post

5 REPLIES 5
harshnathani
Community Champion
Community Champion

@Anonymous ,

 

Please see if the below link works for you.

 

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

 

Regards,

Harsh Nathani

 

Anonymous
Not applicable

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

 

Thanks for your help.

@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
Not applicable

@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?

 

Capture.PNG

 

Thanks,

Harriet

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors