PRODUCT
The product of a column's numbers.
Group: Aggregation. Compatible with DAX.
Syntax
PRODUCT ( <column> )| Parameter | Type | Description |
|---|---|---|
column | Column | A column of numbers. |
Returns
Number. The column's values multiplied together, blanks left out.
Remarks
- With no value in the filter context, the result is BLANK.
- Products grow fast: over many rows, a growth factor such as 1 + a rate is the usual use.
Examples
Four prices multiplied
EVALUATE
ROW ( "Product of prices", PRODUCT ( Products[Price per liter] ) )| Product of prices |
|---|
| 3793920 |