Power QueryExercises

Anti join

A merge that returns rows with no match: left anti for rows only in the first table, right anti for rows only in the second.

Anti joins are the quickest data-quality check in Power Query: which orders have no customer, which products have no price, which accounts disappeared since last month. The result has the first table's columns only, so remove the empty nested column it adds.

In the Power Query editor

Left Anti or Right Anti in the Merge dialog's Join Kind list.

Learn more

Practise it

Related terms