Returns the maximum of values found in the tuples of a set.
Syntax
Max ( set [,numeric_value_expression ] )
Parameter | Description |
---|---|
The set to search for values. | |
numeric_value_expression | Optional numeric value expression (see MDX Grammar Rules). |
Notes
The return value of Max is #MISSING if either of the following is true:
The input set is empty.
All tuple evaluations result in #MISSING values.
Example
WITH MEMBER [Measures].[Max Qtr2 Sales] AS 'Max ( {[Year].[Qtr2]}, [Measures].[Sales] )' SELECT { [Measures].[Max Qtr2 Sales] } on columns, { [Product].children } on rows FROM Sample.Basic
(axis) | Max Qtr2 Sales |
---|---|
Colas | 27187 |
Root Beer | 27401 |
Cream Soda | 25736 |
Fruit Soda | 21355 |
Diet Drinks | 26787 |