List.Product

List.Product is a Power Query M function that calculates the product of the non-null numbers in a list. The function returns the product or null if there are no non-null values in the list.

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

Syntax

List.Product(
   numbersList as list,
   optional precision as nullable number,
) as nullable number

Description

Returns the product of the non-null numbers in the list, numbersList. Returns null if there are no non-null values in the list.

Examples

Find the product of the numbers in the list {1, 2, 3, 3, 4, 5, 5}.

// Output: 1800
List.Product( {1, 2, 3, 3, 4, 5, 5} )

Learn more about List.Product in the following articles:

Other functions related to List.Product are:

BI Gorilla Youtube Channel

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