topic Re: Counts of Deactivated Counts in DAX Commands and Tips

Counts of Deactivated Counts

Anonymous — Tue, 22 Nov 2022 20:43:43 GMT

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

FreemanZ — Tue, 22 Nov 2022 21:43:51 GMT

hi Anonymous

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)

)

Anonymous — Wed, 23 Nov 2022 20:37:41 GMT

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

Please help

FreemanZ — Wed, 23 Nov 2022 23:09:56 GMT

Anonymous

what error or notification do you get?

Anonymous — Thu, 24 Nov 2022 14:52:34 GMT

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

FreemanZ — Thu, 24 Nov 2022 15:08:12 GMT

A bit strange, I have verified it actually.

the data sample

would you mind share the simplified file?