<!-- https://learnsql.cpetoday.com/functions/m/list-product -->
# List.Product

Language: Power Query M
Category: List: summarize
Syntax: List.Product(list)
Summary: Multiplies all the numbers in a list together.
Returns: A number, the product of the list.
Level: Intermediate
Related: List.Sum, List.Transform, List.Average, List.Count, List.Accumulate

## What it does
List.Product multiplies every number in a list. In finance, the common case is a set of growth factors or rates that compound over time. If each month's factor is 1 plus the monthly return, the product is the total growth over the period. It is the multiplication counterpart of List.Sum.

## Syntax and arguments
- `list`: the numbers to multiply. Use factors such as 1.02, not percentages such as 2.

## Example
An investment grows 1 percent in each of three months. The analyst wants the total growth over the quarter.

```powerquery
let
    MonthlyFactors = {1.01, 1.01, 1.01},
    QuarterFactor = List.Product(MonthlyFactors),
    QuarterGrowth = QuarterFactor - 1
in
    QuarterGrowth
```

The result is about 0.0303, or 3.03 percent, because 1.01 times 1.01 times 1.01 is 1.030301. Growing 1 percent three times gives slightly more than 3 percent, which is why compound figures differ from simple sums.

## Example: a second, different use
Computing a cumulative index from a list of monthly price changes, where each change is a factor such as 0.98 for a 2 percent fall.

## Things to watch
- Use factors, not percentages. A list containing 2 (meaning 2 percent) multiplies everything by 2 and gives a wrong answer.
- A single zero makes the whole product zero, which can be a real result or a data error.
- With many large numbers the product can get very big. Check the size before you report it.
- For a running product, List.Accumulate with a multiplication gives every step, not only the last.

## In business terms
Compound growth, cumulative price indexes, the combined effect of several rate changes and survival factors for collections all use products. Show the factors in the workpaper so the result can be reproduced.
