Downloads
DAXAggregationAdvanced

PRODUCT

Multiplies together the numbers in a column.

Syntax
PRODUCT(<column>)

Returns: A number (a scalar). BLANK when the column has no numbers in the current filter context.

What it does

PRODUCT multiplies every number in a column together. It is the multiplicative twin of SUM. Its main finance use is chaining growth factors: if each period grows by a rate, the cumulative growth is the product of the period factors, not the sum of the rates. Use it when values compound instead of add up.

Syntax and arguments

Example

The FP&A team has a table of monthly price index factors, where 1.02 means a 2 percent rise in that month. They want the cumulative price change over the year.

Cumulative Price Factor = PRODUCT(PriceIndex[MonthlyFactor])

Subtract 1 and format as a percentage to get the cumulative change. A column with factors of 1.02 applied twelve times gives a larger result than twelve times 2 percent added together, which is the reason the product is the correct method.

Example: a second, different use

Compounded return on a set of periods where the return for each period is a column of factors such as 0.98 or 1.05:

Compounded Return = PRODUCT(Returns[PeriodFactor]) - 1

Multiplying the factors gives the total effect of all periods, which is the number an investment or a cost index needs.

Things to watch

In business terms

PRODUCT is used for cumulative inflation, compounded investment returns, chained exchange rate effects and survival rates in a retention study. Any time the result of one period feeds into the next, multiplication is the right operator.

Related functions

All DAX functions · View as Markdown · DAX fundamentals