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

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.