fbpx

Max (MDX)

Returns the max value of the specified set expression.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  value-expression  zero-one   

Return

value

Description

The max function calculates the max value of the non-empty cells.

1) A value expression is specified.

When the value expression is specified, the measure is evaluated over the set and its max value is returned.

2) A value expression is not specified.

If a value expression is not specified, the measure is taken from the current context.

See Also

Avg Min Median Sum Vector

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.