Syntax

Min ( set [,numeric_value_expression ] )

Parameters

set

The set to search for values.

numeric_value_expression

Optional numeric value or an expression that returns a numeric value.

Notes

The return value of Min is #MISSING if either of the following is true:

• The input set is empty.

• All tuple evaluations result in #MISSING values.

Example

For every quarter, the following MDX query displays the minimum monthly sales value.

WITH MEMBER
 [Measures].[Minimum Sales in Quarter]
AS 
 'Min ([Year].CurrentMember.Children, [Measures].[Sales])'
SELECT
 {[Measures].[Minimum Sales in Quarter]}
ON COLUMNS,
 [Year].Children
ON ROWS 
FROM Sample.Basic

The above query returns the following output: