Headcount Using Hire Date & Term Date Power Query

[goob90]

Every week I run a report from our HRIS and drop a CSV file into a folder that is connected to Excel via PQ. I use the cleaned-up data to "feed" pivot tables and use them in a dashboard.

I have no problem getting a current headcount, but I would like to be able to get a headcount for each month of the year, dating back to 2016.

The data includes employee id, employee name, hire date, termination date, and status. Below is a sample using fictional data.

Dashboard.xlsx
	A	B	C	D	E
1	Emp ID	Name	Hiredate	Term Date	Status
2	101	John Hermiston	1/1/1999	12/31/2016	Terminated
3	104	Mrs. Ahmad Donnelly	7/1/2008	2/28/2022	Terminated
4	112	Geo Ondricka	10/8/2012	12/26/2018	Terminated
5	113	Chester Walsh	10/13/2003		Active
6	114	Gilberto Bashirian	11/17/2003		Active
7	117	Abby Tremblay	2/25/2002	9/13/2019	Terminated
8	118	Chaim Boehm	6/9/2014	3/13/2019	Terminated
9	119	Jarred Smitham	8/29/2014	3/13/2019	Terminated
10	120	Miss Lauriane Luettgen	8/29/2014	1/25/2019	Terminated
11	121	Reid Dooley	2/7/2016		Active
12	122	Kristina Stanton	5/9/2016		Active
13	124	Ms. Annamarie Mertz	4/3/2017	5/2/2019	Terminated
14	125	Roman Heidenreich	2/5/2018		Active
15	126	Mrs. Dorian Heaney	3/20/2019	6/30/2022	Terminated
16	127	Gustave Rosenbaum	4/8/2019	11/4/2019	Terminated
17	128	Cullen Considine	7/29/2019	3/20/2020	Terminated
18	129	Jarvis Schinner	9/3/2019		Active
19	130	Chyna Stanton V	11/8/2019		Active
20	131	Daija McLaughlin	12/22/2019	6/30/2022	Terminated
21	132	Miss Jolie Smitham	9/14/2020	1/1/2022	Terminated
22	133	Sarai Sipes I	12/14/2020		Active
23	134	Lee Hayes	4/13/2021		Active
24	135	Terrence Maggio V	5/24/2021	5/26/2021	Terminated
25	136	Lia Volkman	6/15/2021		Active
26	137	Amelia Schamberger	6/13/2022		Active
27	138	Jay Casper III	7/4/2022		Active
28	139	Maximilian Aufderhar	7/11/2022		Active
29	201	Mrs. Vilma Kuhic	8/12/1996		Active
30	203	Donnie Johnston	1/30/2017		Active
31	206	Rico Mayert	11/28/2005		Active
32	402	Alanna Brakus	3/24/2014		Active
33	409	Jillian Collins	9/15/2008	3/15/2016	Terminated
34	411	Emerald Schuster	6/17/2002	5/11/2017	Terminated
35	413	Judson Hilll I	10/13/2014		Active
36	414	Emma Jerde II	6/13/2016	7/27/2018	Terminated
37	415	Anne Lehner	6/13/2016	2/14/2022	Terminated
38	416	Sally Veum	1/30/2017	4/11/2022	Terminated
39	417	Zoie Keebler	5/22/2017	3/4/2019	Terminated
40	418	Maye Walter	1/2/2019		Active
Sheet40

I've done a little research and it was suggested that I create a calendar table in PQ, which I have done, but I am not sure what I should do next. Any suggestions?