Comparing Data Sets from two sets of data

[ScholarPunk]

Team,

Looking for some help. My work pulls daily reports where an unique identifier exists for each customer. Looking for a better way to compare yesterday's report to today's report. Looking to only show what exists from todays report by customer ID (either the ones that existed both yesterday and today along with the new additions that only are on today) while some how highlighting or only leaving the changed data for customers that were on yesterday's report and had some sort of update. Example below

 

[ScholarPunk]

Team,

Looking for some help. My work pulls daily reports where an unique identifier exists for each customer. Looking for a better way to compare yesterday's report to today's report. Looking to only show what exists from todays report by customer ID (either the ones that existed both yesterday and today along with the new additions that only are on today) while some how highlighting or only leaving the changed data for customers that were on yesterday's report and had some sort of update. Example below

View attachment 102334

Preferably using Power Query