How to compare same rows in a table

Anonymous , we need to know the basis of the date. Using non continuous date logic or week behind or days behind logic we need to get those as current and prior and check

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9

The dates are just the names of the files, hopefully the pic below will explain it. 

Sorry for the vague description. Basically, I have 2 tables from different dates. Each table contains 20 000+ rows. The rows contains an ID (GUID) which is a unique text + number string. For each ID there a values, some just number values and some are text values. These two tables also have a mismatch in the numbers of IDs. So I want in my visualisation to filter IDs that are new or missing and values that has changed. I'm a beginner in DAX...

Hi Anonymous 

I think you can use power query to merge the two table，then  press close & apply

then   add a column to compare the two column

like if（【2022-04-30】 = 【2022-04-22】，1，0）

then  filter the data by click the arrow on the column

Best Regards,

Community Support Team _Isabella

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.