Counts of Deactivated Counts

[SandhyaGiriraj]

Date	Source	Acc
07/01/2022 12:00AM	A	0111
07/01/2022 12:00AM	B	0101
08/01/2022 12:00AM	A	0111
08/01/2022 12:00AM	B	0101
09/01/2022 12:00AM	A	0200
09/01/2022 12:00AM	B	0211

I have to find the counts of deactivated Acc. 

Example, In Current Month September the account 0111 and 0101 is deactivated when comparing august. 

My current Month will change everymonth. So my DAX should be dynamic.

Help would be much appreciated

[SandhyaGiriraj]

@FreemanZ ,

When I add this formula I am getting blank. No Counts

[FreemanZ · Accepted solution]

A bit strange, I have verified it actually. 

the data sample

 would you mind share the simplified file?

[FreemanZ]

hi @SandhyaGiriraj 

i see you make a new post. i thought the missing account in the previous post reply is Deactivated Account, make sense?

CountMissing =

VAR AccListCurrent =  

    VALUES (TableName[AccNO])

VAR AccListLastMonth =

    CALCULATETABLE(

        VALUES(TableName[AccNO]),

        DATEADD(TableName[Date], -1, MONTH)

    )

RETURN

    COUNTROWS(

        EXCEPT( AccListLastMonth, AccListCurrent)

    )

[SandhyaGiriraj]

@FreemanZ ,

This formula is not working as expected. Is there any other option to do it.

Please help

[FreemanZ]

@SandhyaGiriraj 

what error or notification do you get?