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 |