← Back to List functions

List.RemoveNulls

Eliminates any instances of "null" values from the list. If the list does not contain any 'null' values, the original list is simply returned.

Syntax

List.RemoveNulls(list as list) as list

About

Eliminates any instances of "null" values from the list. If the list does not contain any 'null' values, the original list is simply returned.

Explanation

Eliminate the "null" values from the set {1, 2, 3, null, 4, 5, null, 6} with the Power Query function MList.RemoveNulls. After executing the command, the output will be {1, 2, 3, 4, 5, 6}.