Min

The Min function finds the minimum value for a column or group.

To find the minimum value across columns, use the Least function.

📘

The Min function is an aggregate function.

Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see Group columns in a table.

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see Add summary statistics to a table.

To learn more about using aggregate functions, see Building complex formulas with grouped data.

Syntax

Min([column])

Function arguments:

• column (required) The column to be searched.

Notes

• The field argument must be a value with the Number, Date, or Text data type.

Examples

Min([Distance])

• In a table summary, returns the shortest Distance across all rows in the table.
• In a calculated column in an ungrouped table, returns each row's own Distance value, because the aggregate is calculated per row.
• In a table grouped by Airline, returns the shortest Distance within each airline's group.

Min([Balance])

• Finds the smallest balance. Could be negative.

Min([Name])

• Finds the first name alphabetically. If Name was “Betty”, “Charles”, and “Anne”, the result would be ”Anne”.

Min([Invoice Date])

• Finds the lowest Invoice Date, which is the invoice date furthest in the past.