MIN Function (DAX)
Returns the smallest numeric value in a column, or between two scalar expressions. Ignores logical values and text.
MIN(<column>)
MIN(<expression1>, <expression2>)
Parameters
| Term | Definition |
|---|---|
| column | The column in which you want to find the smallest numeric value. |
| expression | Any DAX expression which returns a single numeric value. |
A decimal number.
The MIN function takes a column or two expressions as an argument, and returns the smallest numeric value. The following types of values in the columns are counted:
Numbers
Dates
If the column contains no numerical data, MIN returns blanks.
Empty cells, logical values, and text are ignored. If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.
Blank is treated as 0 when comparing. That is, Min(1,Blank() ) returns 0, and Min( -1, Blank() ) returns -1. If both arguments are blank, MIN returns a blank.
If either expression returns a value which is not allowed, MIN returns an error.
The following example returns the smallest value from the calculated column, ResellerMargin.
=MIN([ResellerMargin])
The following example returns the smallest value from a column that contains dates and times, TransactionDate. This formula therefore returns the date that is earliest.
=MIN([TransactionDate])
The following example returns the smallest value from the result of two scalar expressions.
=Min([TotalSales], [TotalPurchases])
MIN Function (DAX)
MINA Function (DAX)
MINX Function (DAX)
Statistical Functions (DAX)