Headcount report on POWER BI

[Vanshika_Gupta]

Headcount report on POWER BI

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.

[v-yangliu-msft]

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

[amitchandak · Accepted 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

[Vanshika_Gupta]

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