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
- intermediate~7 minFree
Treat empty text and null the same (hardware)
Some suppliers are null and some are empty text. Standardise both to "Unknown".
- intermediate~8 minFree
Predict which orders a filter will drop, nulls included (kite shop)
Before a Qty ≥ 3 filter goes live, list exactly the orders it will remove, including the ones with no quantity.
- beginner~7 minFree
Convert Yes/No answers to true, false or null (charity)
The marketing opt-in column mixes Yes, Y, no, N, blanks and nulls. Turn it into a proper true/false column.