Share via


MIN Function

Returns the smallest numeric value in a column. Ignores logical values and text.

Syntax

MIN(<column>)

Parameters

Term

Definition

column

The column in which you want to find the smallest numeric value.

Return Value

A decimal number.

Remarks

The MIN function takes a column as an argument, and returns the smallest numeric value in the column. The following types of values in the columns are counted:

  • Numbers

  • Dates

  • If the column contains no numerical data, MIN returns blanks.

Empty cells, logical values, and text are ignored. If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.

Example

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

See Also

Reference

MIN Function

MINA Function

MINX Function

Other Resources

Statistical Functions (DAX)