List.Product
All the numbers of a list multiplied together, nulls left out.
Group: List. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
List.Product(numbersList as list, optional precision as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
numbersList | list | Numbers; nulls are skipped. |
precision | nullable number optional | Precision.Double (the default) multiplies as double-precision numbers; Precision.Decimal as decimals of 15 significant digits. |
Returns
nullable number. The product; null when the list has no number.
Examples
Units on a pallet
12 cartons a layer, 4 layers, 6 units a carton.
List.Product({12, 4, 6})288