Find missing, new and base accs

Anonymous — Mon, 14 Nov 2022 14:11:21 GMT

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

Re: Find missing, new and base accs

Anonymous — Tue, 15 Nov 2022 05:53:36 GMT

HI Anonymous,

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

topic Re: Find missing, new and base accs in Developer

Find missing, new and base accs

Re: Find missing, new and base accs