List.NonNullCount
How many items of a list are not null.
Group: List. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
List.NonNullCount(list as list) as number| Parameter | Type | Description |
|---|---|---|
list | list | The list whose values you count. |
Returns
number. The number of items that are not null.
Examples
Days with a reading
A week of meter readings, two days missing.
List.NonNullCount({412, 418, null, 431, null, 440, 446})5