MIN

Applies to: Calculated column Calculated table Measure Visual calculation

Returns the smallest value in a column, or between two scalar expressions.

Syntax

DAX
MIN(<column>)  
DAX
MIN(<expression1>, <expression2>)

Parameters

Term Definition
column The column in which you want to find the smallest value.
expression Any DAX expression which returns a single value.

Return value

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.

DAX
= 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.

DAX
= MIN([TransactionDate])  

Example 3

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

DAX
= Min([TotalSales], [TotalPurchases])

MINA function
MINX function
Statistical functions