## How does the MIN function (DAX) work?

MIN function returns a column’s smallest value, or between two scalar expressions.

## MIN Formula Syntax

= MIN(
<column>
)

= MIN(
<expression1>,<expression1>
)

## How do you use the MIN function?

The MIN function takes as an argument a column or two words, and returns the smallest value. The following values are counted in the columns:

• Numbers
• Texts
• Dates
• Blanks

## Considerations when using the MIN function

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. MIN returns an error if either expression returns a value that is not allowed.

TRUE/FALSE values are not supported. If you want to evaluate a column of TRUE/FALSE values, use the MINA function.

## Formula examples using the MIN 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]
)