List.NonNullCount

List.NonNullCount is a Power Query M function that counts the non-null items in a list. The function returns the number of non-null items in the list.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

List.NonNullCount( list as list ) as number

Description

Returns the number of non-null items in the list list.

Related functions

Other functions related to List.NonNullCount are:

• List.Average
• List.Count
• List.Covariance
• List.Median
• List.Mode
• List.Modes
• List.Percentile
• List.Product
• List.StandardDeviation
• List.Sum

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/list-nonnullcount
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.