keep up the HR analytics work - Power BI youtubers tend to focus on Product rather than People :). You've been a great resource so far! Look forward to future videos!
Another Excelent video! Thanks For sharing! I have a question and I hope you can help me. To calculate turnover and headcount I linked my calendar table to my main table using your trick of deactivate the relationships and then activate them using the USERELATIONSHIP function. That part is working fine. However, Now I am calculating the hire retention in a granular way during a 3-month period. I can say for each new hire, if they remain in the company after 3 months, but I had to use a different calendar. How can I use just one calendar table to calculate this and also turnover, headcount and all the other metrics? I have tried everything but can't find a solution different than two use two different calendars
Very useful video, I was stuck at the point to make the relation between joining date and relieving date of a staff at a particular branch, then presenting staff strength comparison at different point of time. This video would be helpful in solving that problem. Thanks for making such videos.
Hello Fernan, thank you for this great video. However, I don't understand why you first established two relationships for start and end date with the calendar when calculating the headcount, but then put the relationships inactive? What's the point in doing so? Sorry, if this question sounds stupid, but I'm super new to PowerBI...just started last week.
Is it best to roll up the absence to months? As I currently have a table for absence which holds the employeeid, absencedate, absencetype, absencehours, your example is based on days but my system uses hours and not sure best way to convert this to days as each employee are on different work patterns
Hi there, generally speaking it's better if you can roll up your data to a higher grouping its better because you'll decrease you dataset size. I would start by calculating individual people's work pattern, working out what their hours per day is and then converting them into days (as decimal)
Hi, very nice video.. I am not able to calculate average employees... As i have only employee code coloumn. Other columns are string datatype Is there any other way we can calculate Avg employee?
Hello - What is the solution to address the scenario where offers are accepted in a particular month for offers sent in the past month, It is resulting in offer acceptance over 100%. Please advise.
How can I have a table or matrix that will show me all records in one table and documents that match in another table and leave blank when there is no match.
Overall Headcount Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH(DATESMTD('Date'[Date]))) vs OverallHC Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH('Date'[Date])) do you know why OverallHC Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH('Date'[Date])) doesn't work? i get the same value as if there's no relationship, but i am referencing the date table in the measures so it should work, the same thing for quarters and previous year. but when i do all of them the first way OverallHC Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH('Date'[Date])) it works.
Hey, your video is the simplest, yet the most explanatory and clear of all I have seen on TH-cam related to HR analytics. Thanks a lot for the effort!
keep up the HR analytics work - Power BI youtubers tend to focus on Product rather than People :). You've been a great resource so far! Look forward to future videos!
I appreciate that Dan, thanks for your kind words!
Great! Do you have more HR KPI´s?
Another Excelent video! Thanks For sharing! I have a question and I hope you can help me. To calculate turnover and headcount I linked my calendar table to my main table using your trick of deactivate the relationships and then activate them using the USERELATIONSHIP function. That part is working fine. However, Now I am calculating the hire retention in a granular way during a 3-month period. I can say for each new hire, if they remain in the company after 3 months, but I had to use a different calendar. How can I use just one calendar table to calculate this and also turnover, headcount and all the other metrics? I have tried everything but can't find a solution different than two use two different calendars
Very useful video, I was stuck at the point to make the relation between joining date and relieving date of a staff at a particular branch, then presenting staff strength comparison at different point of time. This video would be helpful in solving that problem. Thanks for making such videos.
Glad it was helpful! To be honest I also had this problem a long time ago until I discovered the power of the Calendar table, thanks for watching!
Hello Fernan, thank you for this great video. However, I don't understand why you first established two relationships for start and end date with the calendar when calculating the headcount, but then put the relationships inactive? What's the point in doing so? Sorry, if this question sounds stupid, but I'm super new to PowerBI...just started last week.
Hi! At 16:26 you summarize average of the headcount measure. Any ideas on why I wouldn't be able to? I'm stumped.
Hi there, is your headcount a measure? You can only implicitly summarise column values not measures
Excellent, thank you
You're welcome, thanks for watching!
Thanks alot. Would you consider maybe explaining how to count "Leavers"?
Hey, for the turnover %, wouldn't the average headcount be the headcount on 1 Jan and headcount on 31st dec divided by 2?
15:10 Employee Turnover Rate
At 6:59 when I drag the headcount the value is repeating on each row? Any ideas as to why
Hi there, sounds like you havent set up your relationships correctly!
What's the measure for leavers?
Is it best to roll up the absence to months? As I currently have a table for absence which holds the employeeid, absencedate, absencetype, absencehours, your example is based on days but my system uses hours and not sure best way to convert this to days as each employee are on different work patterns
Hi there, generally speaking it's better if you can roll up your data to a higher grouping its better because you'll decrease you dataset size. I would start by calculating individual people's work pattern, working out what their hours per day is and then converting them into days (as decimal)
Hi, very nice video..
I am not able to calculate average employees... As i have only employee code coloumn. Other columns are string datatype
Is there any other way we can calculate Avg employee?
Hello - What is the solution to address the scenario where offers are accepted in a particular month for offers sent in the past month, It is resulting in offer acceptance over 100%. Please advise.
How to create MoM annualized attrition for the financial year by overall and by department level. .pls help
How did you calculate the leavers?
how did you calculate leavers?
how did you get the monthly headcount and leavers count in turnover table for turnover calculation??? its not a measure
Hi, for the demo I think I just summarised them into columns in a table
How can I have a table or matrix that will show me all records in one table and documents that match in another table and leave blank when there is no match.
Hi, unrelated to this video but I've covered it here: th-cam.com/video/294BH6vOpcs/w-d-xo.html
You should put the data link
Hi there, demo files are available here: www.patreon.com/posts/demo-files-52538104
Overall Headcount Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH(DATESMTD('Date'[Date]))) vs OverallHC Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH('Date'[Date])) do you know why OverallHC Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH('Date'[Date])) doesn't work? i get the same value as if there's no relationship, but i am referencing the date table in the measures so it should work, the same thing for quarters and previous year. but when i do all of them the first way OverallHC Prior Month = CALCULATE([Overall Headcount], PREVIOUSMONTH('Date'[Date])) it works.
IF I am using your headcount measure i am getting blank can anyone help me
How do you calculate HR attrition?
Hi Denwo, there are many ways you can calculate attrition, the standard way would be total leavers in period / average headcount in period
@@SolutionsAbroad thanks for your reply! So what would the calculation be for Turnover or is that the same?
@@denwo1982 Yep that's what I normally use as a standard