Distinct count of employee who left the company in that particular month (Attrition)

[Anonymous]

Hi All,

I am new to Power BI/DAX, need your help to calculate Attrition measure for the below data:

Input
Month	Employee key	Last working Day
1/1/2022	1111	null
1/1/2022	1112	21/01/2022
1/1/2022	1113	null
2/1/2022	2222	15/02/2022
2/1/2022	2220	13/02/2022

And my ouput should be:

Output
Month	Attrition
Jan-22	1
Feb-22	2

Please help me to get this logic for me,

Thanks

[Watsky · Accepted solution]

Hi @Anonymous , If the Last Working Day column's data type is date you can do...

CALCULATE (
COUNTA ( 'Table'[Employee key] ),
ISBLANK ( 'Table'[Last working Day] ) = FALSE ()
)

if the Last Working Day column's data type is text then you can do....

CALCULATE (
COUNTA ( 'Table'[Employee key] ),
'Table'[Last working Day] <> "null"
)