Type.IsNullable
This function indicates whether a specific type is nullable or not. It returns true for nullable types and false for non-nullable types.
This function indicates whether a specific type is nullable or not. It returns true for nullable types and false for non-nullable types.
Example 1:
Check if a number can have a null value.
Usage:
In Power Query M, use Type.IsNullable(type number) function.
Output:
false
Example 2:
Check if a nullable number type can have a null value.
Usage:
In Power Query M, use Type.IsNullable(type nullable number) function.
Output:
true