HR Headcount and Attrition Dashboard

[AkameNoGamma]

I created a new post to attached the pbix file for ease of sharing

I originally posted this on Reddit as I was looking for a reference on how to get the starting and closing headcount for each department within my company, which includes the movements from one department to another. A couple of hours after posting it, I came up with a solution to get the actual attrition and headcount of each department, but there is a caveat. 

Please note that because my dashboard is only covering the headcount and attrition starting the fiscal year of April 2022 to March 2023 (and onwards), the formula below will only work if you have the list of employees with their original department starting April 2022. 

feel free to analyze the formula that I used and let me know if you have any suggestions to improve it. I only got this far because of the sources here and by the help of chatgpt. i never had a proper lesson for PowerBI, so feel free to correct me if there are any issues with the method that i used.

https://drive.google.com/file/d/1SL4GkgXEKWe1JMyXs2GXMmu0im6XlTke/view?usp=sharing

[Anonymous · Accepted solution]

HI @AkameNoGamma,

It sounds like a common multiple date field range analisis requirements, perhaps you can take a look at the following blog start end date part if they suitable for your requirement:

Before You Post, Read This: start, end date  

Regards,

Xiaoxin Sheng

[AkameNoGamma]

Thank you for sharing this! i checked it and it is kind of similar to what i am using right now, though the one that i'm currently figuring out is more to do with the opening headcount of a month for a department. i can't find a better way to represent the headcount than the one that i posted here, which is relying on list of employees with their department for a given month. and due to limitation of my data, i'm stucked only for April 2022, which is fine by me since i could just whipped out the old data from excel for past fiscal years.

if i found a better way, i will update this post to help out those that are measuring attrition and headcount similar to what i have been doing.