DAX Function Guide

MIN
Empty image or helper icon

Sam McKay

CEO & Founder

How does the MIN 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?

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

Loading

Considerations when using the MIN?

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

Loading

Formula examples using the MIN

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 Courses

Loading