Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Min (MDX)

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

Min( Set_Expression [ , Numeric_Expression ] )

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


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.


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 
      , [Measures].[Reseller Order Quantity]
SELECT Measures.x ON 0
,NON EMPTY [Date].[Calendar].[Calendar Quarter]* 
   [Product].[Product Categories].[Subcategory].members *
ON 1
FROM [Adventure Works]

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.