List.Count

List.Count is a Power Query M function that calculates the number of items in a given list. The function returns the total item count for the list.

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

Syntax

List.Count( list as list ) as number

Description

Returns the number of items in the list list.

Examples

Find the number of values in the list {1, 2, 3}.

// Output: 3
List.Count( {1, 2, 3} )

Related articles

Learn more about List.Count in the following articles:

• Lists in Power Query M / List Functions (200+ Examples)
  The complete guide to Lists in Power Query M. Learn from practical examples and master Power Query’s most powerful List functions. » Read more

Related functions

Other functions related to List.Count are:

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

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