PRODUCT is a DAX function that returns the product of all numbers in a specified column.
Syntax
PRODUCT( ColumnName )| Argument | Properties | Description |
|---|---|---|
| ColumnName | Column that contains values for product. |
PRODUCT
Updated on
PRODUCT is a DAX function that returns the product of all numbers in a specified column.
PRODUCT( ColumnName )| Argument | Properties | Description |
|---|---|---|
| ColumnName | Column that contains values for product. |
A decimal number.
To return the product of an expression evaluated for each row in a table, use PRODUCTX function.
Only the numbers in the column are counted. Blanks, logical values, and text are ignored. For example,
PRODUCT( Table[Column] ) is equivalent to PRODUCTX( Table, Table[Column] ).
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
The following computes the product of the AdjustedRates column in an Annuity table:
= PRODUCT( Annuity[AdjustedRates] )
Other functions related to PRODUCT are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy