MIN - Daxplained

MIN is a DAX function that returns the smallest numeric value or smallest string in a column, or the smaller value between two scalar expressions.

Syntax

MIN(
   ColumnNameOrScalar1,
   Scalar2
)

Argument	Properties	Description
ColumnNameOrScalar1		The column in which you want to find the smallest numeric value or smallest string in a column, or the first scalar expression to compare.
Scalar2	Optional	The second number to compare.

Return Values

The smallest value.

Remarks

The MIN function takes a column or two expressions as an argument, and returns the smallest value. The following types of values in the columns are counted:
- Numbers
- Texts
- Dates
- Blanks
When comparing expressions, 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.
TRUE/FALSE values are not supported. If you want to evaluate a column of TRUE/FALSE values, use the MINA function.

Example 1

The following example returns the smallest value from the calculated column, ResellerMargin.

= MIN([ResellerMargin])

Example 2

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])

Example 3

The following example returns the smallest value from the result of two scalar expressions.

= Min([TotalSales], [TotalPurchases])

Other functions related to MIN are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/min-function-dax