Power QueryExercises

Left outer join

A merge that keeps every row of the first table and adds matches from the second, with null where there's no match. The usual choice for lookups.

Rows of the first table are never lost, so totals based on it stay correct. Rows without a match get null in the expanded columns, which makes missing lookups easy to spot by filtering for null. If the lookup has duplicate keys, the first table's rows can multiply.

In the Power Query editor

Left Outer is the default in the Merge dialog; it's JoinKind.LeftOuter in M.

Learn more

Practise it

Related terms