TechNet
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Collapse the table of content
Expand the table of content
Expand Minimize
This documentation is archived and is not being maintained.

Max (MDX)

Updated: 12 December 2006

Returns the maximum value of a numeric expression that is evaluated over a set.


Max( Set_Expression [ , Numeric_Expression ] )

Set_Expression

A valid Multidimensional Expressions (MDX) expression that returns a set.

Numeric_Expression

A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.

If a numeric expression is specified, the specified numeric expression is evaluated across the set and then returns the maximum value from that evaluation. If a numeric expression is not specified, the specified set is evaluated in the current context of the members of the set and then returns the maximum value from that evaluation.

ms145601.note(en-US,SQL.90).gifNote:
Analysis Services ignores nulls when calculating the maximum value in a set of numbers.

Example

The following example returns the maximum quarterly sales for each subcategory and each country in the Adventure Works cube.

WITH MEMBER Measures.x AS Max 
   ([Date].[Calendar].CurrentMember.Children
      , [Measures].[Reseller Order Quantity]
   )
SELECT Measures.x ON 0
,NON EMPTY [Date].[Calendar].[Calendar Quarter]* 
   [Product].[Product Categories].[Subcategory].members *
   [Geography].[Geography].[Country].Members
ON 1
FROM [Adventure Works]

Release History

12 December 2006

Changed content:
  • Clarified impact of nulls.

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.
Show:
© 2016 Microsoft