PRODUCT Function (DAX)

 
System_CAPS_ICON_note.jpg Note


This function is included in SQL Server 2016 Analysis Services (SSAS), Microsoft Power Pivot in Excel 2016 Preview editions, and Microsoft Power BI Designer Preview only. Information provided here is subject to change.

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

TermDefinition
columnThe 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] )  

PRODUCTX Function (DAX)

Community Additions

ADD
Show: