Least

Returns the smallest value from two or more values with matching data types.

Syntax

Least(input1, [input2], ...)

input (required) The data or column of data to be evaluated. Input can be numbers, dates, or strings.

input 2+ (optional) Additional inputs to compare. All additional inputs must match the type of the first input.

Notes

• To compare two values of different data types, convert one of the values to match the data type of the other using the appropriate type conversion function. For example, you can convert a string to a number using the Number function, or to a date using the Date function.

Examples

Least(1, 2)

• Returns 1.

Least([Date], Date("2025-12-20"))

• In a calculated column, converts the text "2025-12-20" to a date, compares it to the date in the Date column, and returns the earlier of the two.

Least([Profit 2022], [Profit 2023], [Profit 2024])

• In a table summary, returns the profit for the year with the lowest profit from among 2022, 2023, and 2024.