Min

Returns the minimum of values found in the tuples of a set.

Syntax

Min ( set [,numeric_value_expression ] )

Notes

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

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: