Multiply (PQL)

* Click on the function's arguments above for more details on the input values.

Comments

The Multiply function returns the product when the elements in the specified list are multiplied. 

Arguments

• The List parameter should be a list or set of elements from an existing hierarchy in the model.
  • The hierarchy name needs to be a unique name with the format [dimension].^[hierarchy] or [table].[column].
• The Data point or tuple is optional, and describes the values used to generate the calculation.
  • If not supplied, the default measure or the query context determines this value instead.

Remarks

• For details on how to employ and use this function see the semantic calculation overview.

Different Function types

• This function is like the MDX Sum function but, instead of summing, it multiplies values across a list of elements in a hierarchy or attribute.
• To use a simple Multiply mathematical operation on a list of numbers, use the Common library function.

Examples

This example returns the product of all Prices in the Date table / dimension, using the sample demo model:

Multiply( AllMembers([Date].[dateKey]), [measures].[Facts Price] )