Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Returns the smallest value in a column, or between two scalar expressions.
MIN(<column>)
MIN(<expression1>, <expression2>)
Term | Definition |
---|---|
column |
The column in which you want to find the smallest value. |
expression |
Any DAX expression which returns a single value. |
The smallest value.
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:
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.
The following example returns the smallest value from the calculated column, ResellerMargin.
= MIN([ResellerMargin])
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])
The following example returns the smallest value from the result of two scalar expressions.
= Min([TotalSales], [TotalPurchases])
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today