How to compare same rows in a table

[hiral]

I wish to compare values presented on the same row in a table and only filter out the rows that differs.

 

[isabella]

Hi @hiral 

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.

[hiral · Accepted solution]

This solved my problem:

= [GUID] <> [#"2022-04-30.GUID"] or [StoreyName] <> [#"2022-04-30.StoreyName"]

[hiral]

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

[hiral]

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

[Ashish_Mathur]

Hi,

In the Query Editor, just merge the 2 tables.

[amitchandak]

@hiral , 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-5c324...