How does the MIN function (DAX) work?
MIN function returns a column’s smallest value, or between two scalar expressions.
MIN Formula Syntax
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:
Related Blog Posts
Related Support Forum Posts
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
The following example returns the smallest value from the calculated column, ResellerMargin.
= MIN (
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 (
The following example returns the smallest value from the result of two scalar expressions.
= MIN (
Related DAX Functions
Related Course Modules
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.