DAX for COUNTING Employee_ID distinctly from Employee Table including current and previous yearmonth

[MRIZ]

I am trying to make Employee Turnover report. I am stuck in making a DAX which can give me output (Table 1) from table (Table 2)
Table 1 want output in Power bi report

YearMonth	Total Number of Employees
24-Jan	4
24-Feb	8
24-Mar	12

Table 2 my employee table

Employee_ID	YearMonth
E11	2023-01
E12	2023-01
E13	2023-01
E14	2023-01
E1	2023-02
E2	2023-02
E3	2023-02
E4	2023-02
E5	2023-03
E6	2023-03
E7	2023-03
E8	2023-03

Here you can see that in the output table (Table 1) every new YEAR-MONTH includes the distinct count of Employee_ID from previous period. 

Plz give me DAX to get Total Number Of Employees  

Thanks.

[tharunkumarRTK · Accepted solution]

@MRIZ 

Please find the file here: Link

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun