Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
2024 | 450 | 434 | 424 | 432 | 433 |
|
|
|
|
|
|
|
2023 | 456 | 435 | 420 | 410 | 413 | 400 | 409 | 403 | 402 | 405 | 400 | 389 |
2022 | 330 | 345 | 378 | 356 | 355 | 350 | 367 | 360 | 389 | 379 | 380 | 387 |
Hey, I am working on HR data on POWER BI whereby I have to calculate headcount i.e. all the active employees present on a particular day....we have with us start date of an employee....so let's say if I want to capture headcount on 31-Mar-24 or 30-Oct-23 what formula should I use so that I can capture all the active employees on that particular date and not just new hires
If I want to build headcount report like this in power BI where I am having columns like start date of employee, end date of employee, name, title, level, etc.
Solved! Go to Solution.
@Vanshika_Gupta , Refer my blog and files for that
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
Thanks for the reply from @amitchandak , please allow me to provide another insight:
Hi @Vanshika_Gupta ,
I created some data:
Here are the steps you can follow:
1. Create calculated table.
Date =
var _table=
CALENDAR(
DATE(2023,1,1),DATE(2024,7,7))
RETURN
ADDCOLUMNS(
_table,"year",YEAR([Date]),"month",FORMAT([Date],"mmmm"))
2. Create measure.
Measure =
var _select=SELECTEDVALUE('Date'[Date])
return
COUNTX(
FILTER('Table',
'Table'[end date of employee]>=_select),[name])
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Vanshika_Gupta , Refer my blog and files for that
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
Hi @amitchandak !! Your video really helped
Is there a way or a video you have made whereby we can even a column parallel to calculate turnover or attrition rate or YOY headcount % rise
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
87 | |
80 | |
69 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |