MIN DAX Function (Aggregation)
Returns the smallest value in a column, or the smaller value between two scalar expressions. Ignores logical values. Strings are compared according to alphabetical order.
Syntax
Parameter | Attributes | Description |
---|---|---|
ColumnNameOrScalar1 |
The column in which you want to find the smallest value, or the first scalar expression to compare. |
|
Scalar2 | Optional |
The second value to compare. |
Return values
Smallest value found in the column or in the two expressions.
Remarks
When used with a single column, the MIN function internally executes MINX, without any performance difference.
The following MIN call:
MIN ( table[column] )
corresponds to the following MINX call:
MINX ( table, table[column] )
The result is blank in case there are no rows in the table with a non-blank value.
When used with two arguments, the syntax:
MIN ( exp1, exp2 )
corresponds to:
VAR v1 = exp1 VAR v2 = exp2 RETURN IF ( v1 < v2, v1, v2 )
Related functions
Other related functions are:
Last update: Dec 7, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen
MSDN documentation: https://docs.microsoft.com/en-us/dax/min-function-dax