Find the difference between datasets

[supermulder]

id, snapshotId, objectName, status

Example Data

1.1,"Test object", active
2,1,"Test object 2", Active
3,2,"Test Object", Inactive
4,2,"Test object 2", Active

Hello,

Assuming I have a table structure like above - how can I display a delta of records where the status has changed between the "snapshots"?

So referring to the above example I want to get the following result 

"Object","Status Old","Status New"

Test object, Active, Inactive

thank you

[Greg_Deckler]

If you do a Merge query in M, it allows you to choose the join type. I'm guessing you would want a Right Anti join?