Min (MDX)

 

Updated: March 2, 2016

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

  
Min( 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 minimum 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 minimum value from that evaluation.

System_CAPS_ICON_note.jpg Note


Analysis Services ignores nulls when calculating the minimum value in a set of numbers.

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

WITH MEMBER Measures.x AS Min   
   ([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]  
  

MDX Function Reference (MDX)

Community Additions

ADD
Show: