HR Headcount and Attrition Dashboard

[AkameNoGamma]

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. After 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.

PowerBI Headcount per Department.docx - Google Docs

[v-heq-msft · Accepted solution]

Hi @AkameNoGamma ,
The URL you provided requires a login to view your request. Please provide a detailed description and steps you can take to provide your desired results in the form of pictures or excel. You can refer to the link below to provide more information
If you are unsure how to upload data please refer to 
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
 https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly