List.Product

This function calculates the product of all non-null numbers in the list called numbersList. If there are no non-null values in the list, the function returns null.

Syntax

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

About

This function calculates the product of all non-null numbers in the list called numbersList. If there are no non-null values in the list, the function returns null.

Explanation

Calculate the product of the numbers in the set {1, 2, 3, 3, 4, 5, 5} using the Power Query MList.Product function. The result will be 1800.