Power QueryExercises

null

M's 'no value'. Arithmetic with null returns null, comparisons with null return null, and filters drop rows whose condition is null.

null is different from empty text "" and from 0. Filters that test [Qty] > 0 drop rows where Qty is null, because the condition isn't true. Functions such as List.Sum ignore nulls, while Fill Down replaces them; the ?? operator supplies a default value.

In the Power Query editor

null cells show the word null in italics; column quality (View tab) reports the percentage of empty values.

Learn more

Practise it