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

2 comments
-
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