Headcount

Topic can be closed, I found a workaround.

Hello,

I am struggling to create the measures that I want. Any help is more than welcome.
It is yet again a headcount problem. I have tried several solutions that I saw on this forum, to no avail.

I am using this summary table, simply called "Headcount" and a calendar table, called "2 - Calendar" with unique dates starting from 01.02.2022.
The two tables are linked through a one to many relationship between "Edition date/ Date". Other tables are linked this way, but I do not think they are relevant here. And the level of details I need is only by month.

The table "Heacount" looks like below:

It is weird in the sense that "Quit" and "Left CC" display a text for the month to come.
Someone who "quitted" in July would be away from August and someone who "Left CC" in the November would actually leave the CC in December.

"New" and "Joined CC" are active on the correct lines.

I would like to have the number of employees starting or quitting per month, as well as the total number of employee per month, and this would be the most important.
I have managed to get the number of employees started with a simple CALCULATE(COUNT,FILTER), but struggle with the rest.

• For the employee quitting, the "Quit" text in on the previous month. The closest I have been is this measure. It displays values for the right month but ignores the filter on "Quit".

I managed to find a solution for "Quit" measure by using:

Quit =
CALCULATE (
    COUNT ( 'Table'[Edition date] ),
    KEEPFILTERS ( 'Table'[Quit] IN { "Quit" } ),
    PREVIOUSMONTH ( '2 - Calendar'[Date] )
)

• For the number of employee per month, I have no clue where to start. All ideas are welcome. The idea is to count 1 for each month an employee is employed, from the month he is new, to the month before he quits.

Thank you by advance for your help.
Also it my first post here, I tried to follow the guide lines much as I could, but please tell me if I missing something.