<!-- https://learnsql.cpetoday.com/functions/dax/product -->
# PRODUCT

Language: DAX
Category: Aggregation
Syntax: PRODUCT(<column>)
Summary: Multiplies together the numbers in a column.
Returns: A number (a scalar). BLANK when the column has no numbers in the current filter context.
Level: Advanced
Related: SUM, POWER, MEDIAN, DIVIDE, RANKX, CALCULATE

## 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
- column: a column reference that holds the numbers to multiply, such as a column of growth factors.

## 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.

```dax
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:

```dax
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
- PRODUCT multiplies, so a single zero makes the whole result zero. Check the column for zeros or blanks.
- Give it factors, not percentages. A value of 2 percent should be 1.02, not 0.02, or the result will be wrong.
- Negative factors flip the sign of the product. Be sure that is what you intend.
- PRODUCT over a fact table with millions of rows can be slow. Keep the list in a small, dedicated table.
- Summing rates to get a total growth figure is a common error. The product is correct for compounding; SUM is correct only for adding amounts.

## 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.
