full anti join (Power Query)
Do a Right and Left Anti Join in one sweep. So figure out the outliers in both tables in one go.
17
votes

3 comments
-
PT commented
Must have please.
-
Sam Thompson commented
Yeah this is a biggy. Understand we can do it with a left and a right anti join but this is two steps too many.
-
Anonymous commented
a frequent need