Downloads
Power Query MList: summarizeIntermediate

List.Product

Multiplies all the numbers in a list together.

Syntax
List.Product(list)

Returns: A number, the product of the list.

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

Example

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

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

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.

Related functions

All Power Query M functions · View as Markdown · M basics