List.Product Function in Power Query

The List.Product function in Power Query is used to multiply all the numeric values in a list together—i.e., it returns the product of the list elements.

Syntax

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

The function has the following parameters:

• List: A list of numbers.
• precision (optional): Defines the numeric precision of the calculation. It accepts:
  • Precision.Double (default)
  • Precision.Decimal

Example: Calculate the product of numbers in a list.

Power Query M

let
    Source = List.Product({5,7})
in
    Source 

The output of the above code is 35.