MAX
Description:
This function is used to return the maximum value of a numeric expression that is evaluated over a set.
Syntax:
Max( Set_Expression [ , Numeric_Expression ] )
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a member. |
Numeric_Expression | It is a valid numeric expression, typically an MDX expression of cell coordinates that returns a number. |
Example:
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].[Sub Category].members *
[Customer].[Geography].[Country].Members
ON 1
FROM [AdventureWorksMF]