Employee headcount by month in stacked column chart

[Anonymous]

Hi All,

I am trying to replicate the excel chart below in Power BI. Also below is some sample data. 

Ultimately what I want is to have the full employee count per month based on hire date and term date, with the range of months being controlled by a slicer. I am having trouble getting an accurate headcount for historical months. Any tips here would be greatly appreciated.

Thanks,

Payroll Name	Status	Hire Date	Termination Date	Category
Employee1	Active	12/01/1993		SG&A
Employee2	Active	07/10/2000		MS
Employee3	Active	02/08/1994		TE
Employee4	Terminated	08/20/2012	10/30/2020	CS
Employee5	Active	07/07/2004		PL
Employee6	Terminated	05/08/2017	01/04/2022	ARC
Employee7	Active	02/01/2016		SG&A
Employee8	Terminated	04/23/2018	12/31/2020	MS
Employee9	Active	07/09/2001		TE

[Anonymous]

Thanks Olga, that worked nicely!

[olgad · Accepted solution]

Hi there, not directly answering your question here, but just wanted to say, the more complex my HR report was the harder was it to maintain the approach of calculating HC in between the dates. May be you just create monthly views, so you can see who is a leaver, joiner, HC in a particular month row wise.

Take a look at the second story in this article, i am always using this approach to avoid the headache.

https://www.linkedin.com/pulse/hr-reporting-generating-records-between-start-end-values-dontsova/?tr...