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
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership