MIN Function (DAX)

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

Related Blog Posts

Related Support Forum Posts

Attrition – why do we use Min?
Date range filtering with multiple tables
New Student Versus Continuing Student Analysis

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.

Related Video Tutorials

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

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.