Forum Discussion
Find missing, new and base accs
| 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
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.
UNION function (DAX) - DAX | Microsoft Learn
Regards,
Xiaoxin Sheng
1 Reply
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.
UNION function (DAX) - DAX | Microsoft Learn
Regards,
Xiaoxin Sheng