Find missing, new and base accs

[SandhyaGiriraj]

R_Date	Acc	Source	F_P
07/01/2022 12:00AM	1234	C	1
07/01/2022 12:00AM	1235	C	2
07/01/2022 12:00AM	1233	B	2
08/01/2022 12:00AM	1233	B	2
08/01/2022 12:00AM	1234	C	2
08/01/2022 12:00AM	1235	C	1

I have to find new, missing and existing accs from the above table in three different table visualization.

For example, above table has an account 1234 in both july and august. But in July the F_P is 1 which means there is one account. but in august they have 2 so one is added that goes into new activation and 1 is existing. 

other example, 1235 in July F_P is 2 which means one account with two different products(phone/tv connection) where as F_P in august is 1 which means the account has deactivated some connection which goes into deact and the other acc goes into existing.

Please Help

[Anonymous · Accepted solution]

HI @SandhyaGiriraj,

Did you mean to add the missed records with 'false' status? If that is the case, you can try to use crossjoin function to get the list of user and item combos.

Then you can compare current table and cross join table records to create a new table with missed records and raw table records.

CROSSJOIN – DAX Guide - SQLBI

UNION function (DAX) - DAX | Microsoft Learn

Regards,

Xiaoxin Sheng