PRODUCT Function (DAX)
|
Returns the product of the numbers in a column.
To return the product of an expression evaluated for each row in a table, use PRODUCTX Function (DAX).
PRODUCT(<column>)
Parameters
| Term | Definition |
|---|---|
| column | The column that contains the numbers for which the product is to be computed. |
A decimal number.
Only the numbers in the column are counted. Blanks, logical values, and text are ignored.
PRODUCT( Table[Column] ) is equivalent to PRODUCTX( Table, Table[Column] )
The following computes the product of the AdjustedRates column in an Annuity table:
=PRODUCT( Annuity[AdjustedRates] )
Community Additions
ADD
Show: