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


List.Count( list as list ) as number


Returns the number of items in the list list.


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

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

Learn more about List.Count in the following articles:

Other functions related to List.Count are:

BI Gorilla Youtube Channel

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.