Returns the minimum of values found in the tuples of a set.
Syntax
Min ( set [,numeric_value_expression ] )
Parameter | Description |
---|---|
The set to search for values. | |
numeric_value_expression | Optional numeric value expression (see MDX Grammar Rules). |
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 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
This query returns the grid:
(axis) | Minimum Sales in Quarter |
---|---|
Qtr1 | 31538 |
Qtr2 | 32917 |
Qtr3 | 33073 |
Qtr4 | 31971 |