MIN
The smallest value in a column, or the smaller of two values (a blank comparing as zero).
Group: Aggregation. Compatible with DAX.
Syntax
MIN ( <column> )
MIN ( <expression1>, <expression2> )| Parameter | Type | Description |
|---|---|---|
column | Column | The column whose smallest value is wanted: numbers, dates or text. |
expression1 | Value | The first of two values to compare. |
expression2 | Value | The second of two values to compare. |
Returns
Same type as its values. The smallest value: of the column's cells, or of the two values given.
Remarks
- With a column, blanks are left out; with no value in the filter context the result is BLANK.
- With two values, a blank compares as zero:
MIN ( 3, BLANK () )is blank. - Text is compared without regard to case. Two values of different types, such as a number and a text, are an error.
- For the smallest value of an expression over rows, use
MINX.
Examples
The first month and the smallest month
EVALUATE
ROW (
"First month", MIN ( Sales[Month] ),
"Fewest liters in a month", MIN ( Sales[Liters] )
)| First month | Fewest liters in a month |
|---|---|
| 2023-11-01 | 47 |
The smaller of two values
EVALUATE
ROW (
"Of 4 and 9", MIN ( 4, 9 ),
"Of 3 and blank", MIN ( 3, BLANK () )
)| Of 4 and 9 | Of 3 and blank |
|---|---|
| 4 | (blank) |