Compare values from 2 rows

One 'brute force' approach would be to seperate the base table into two in Power Query, each filtered respectively for the 1 or 2, then LEFT OUTER JOIN them together on Unique ID and look for nulls.

Another approach would be to create a measure that is the MAX(SubmitTo) and when you view the list by UniqueID, look for any where the MAX is 1 instead of 2.

I'm sure there are more ways.

Hi gauravnarchal ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

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