PRODUCT Function (DAX)

How does the PRODUCT function (DAX) work?

The PRODUCT function (DAX) returns the product of the numbers in a column.

PRODUCT Formula Syntax

PRODUCT(
     <column>
)

How do you use the PRODUCT function?

The PRODUCT function internally executes PRODUCTX, without any performance difference.

Related Blog Posts

Related Support Forum Posts

SWITCH & Ranking is just amazing!
Product Name as Measure for Highest Sales Product
New Customer, Product – Forecast Vs Actual

Considerations when using the PRODUCT function

Only the numbers in the column are counted. Blanks, logical values, and text are ignored.

Related Video Tutorials

Formula examples using the PRODUCT function

=PRODUCT( Annuity[AdjustedRates] )

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formula Reference Guide