DAX Function Guide

PRODUCTX
Empty image or helper icon

Sam McKay

CEO & Founder

How does the PRODUCTX work?
The PRODUCTX function (DAX) returns the product of the numbers resulted from an expression evaluated for each row in a table.
PRODUCTX Formula Syntax

PRODUCTX(
     <table>, <expression>
)

How do you use the PRODUCTX?

The PRODUCTX function takes as its first argument a table, or an expression that returns a table. The second argument is a column that contains the numbers for which you want to compute the product, or an expression that evaluates to a column.

Related Blog Posts

Loading

Considerations when using the PRODUCTX?

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

Related Video Tutorials

Loading

Formula examples using the PRODUCTX

=[PresentValue] * PRODUCTX (AnnuityPeriods, 1 + [FixedInterestRate])

Related Courses

Loading