M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]

Null Values

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

In Power Query, null values represent missing or undefined data. They are similar to NULL in databases and NaN (Not a Number) in Excel but are specifically handled in Power Query as a distinct data type.