Min (MDX)

Returns the min value of the specified set expression.

Parameters

Name	Type	Cardinality	Default value
	set-expression	one
	value-expression	zero-one

Return

value

Description

The min function calculates the min value of the non-empty cells.

1) A value expression is specified.

When the value expression is specified, the measure is evaluated over the set and its min value is returned.

2) A value expression is not specified.

If a value expression is not specified, the measure is taken from the current context.

Examples

Min(set)

Min Amount
1.0

Special Examples (errors, null, ...)

Min(NULL), Min({})

Returns an empty cell if applied to an empty set or a NULL entity.

Query

WITH
    MEMBER [Measures].[Min Amount] AS Min( null )
SELECT
    [Measures].[Min Amount] ON 0
FROM
    [Sales]

Result

Min Amount

Min Amount

Assertion : Cell Equals

WITH
    MEMBER [Measures].[Min Amount] AS Min({})
SELECT
    [Measures].[Min Amount] ON 0
FROM
    [Sales]