List.RemoveNulls
A list without its null items.
Group: List. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
List.RemoveNulls(list as list) as list| Parameter | Type | Description |
|---|---|---|
list | list | The list. |
Returns
list. The other items, in their order.
Remarks
- Empty texts and zeros stay: only null is removed.
Examples
Readings that came in
List.RemoveNulls({412, null, 431, "", 0, null}){412, 431, "", 0}