DAX - Filter on Same Column for Unique Values

[gavs73]

Hi, would appreciate any help with this, I have a list of accounts with an Active Date, which is updated every month and account is live.

I want to count the Unique Accounts in Month 1 NOT IN Month 2, i.e. those which have been LOST, and

I want to count the Unique Accounts in Month 2 NOT in Month 1, i.e. those which are NEW.

In SQL I believe I could just delete one list from the other and count the remainders, is there a similar function in PowerBI DAX ?

Thanks in advance for any help.

Gav


P1Move =

VAR EndDate1 = DATE(2021,01,31)

VAR StartDate1 = DATE(2021,01,01)

VAR EmdDate2 = DATE(2020,12,31)

VAR StartDate2 = DATE(2020,12,01)


VAR UniqueCnt = CALCULATE(

(DISTINCTCOUNT(CorpBill[AccountID])),

CorpBill[xdate]>=StartDate1,CorpBill[xdate]<=EndDate1),

NOT IN ? – Is there DAX for this ?

FILTER(CorpBill[AccountID],

(CorpBill[xdate]>=StartDate2,CorpBill[xdate]<=EndDate2))

)

Return

UniqueCnt