Headcount Calculation (Monthwise, quarterwise, yearwise)

[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,

[Anonymous · Accepted solution]

Hi @Vanshika_Gupta ,

Thank you for @ExcelMonke answer , and I have other suggestions:

Below is my table:

It has employee columns, start date and end date and status columns for active or inactive.

The following DAX might work for you:

Measure = 
  CALCULATE(COUNT('Table'[Customer]),FILTER('Table','Table'[Flag] = "active"))

The final output is shown in the following figure:

Best Regards,

Xianda Tang

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

[ExcelMonke]

Hello, 
Assuming your data is straightforward (i.e. you have 1 date column, 1 column for employee, 1 column for active status, etc.), you should be able to complete this with a simple date slicer on your report.

If it's more complex, please share a bit more about how your data is structured.