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 1...
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
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