fbpx
Select Page

Returns the smallest value amongst the inputs.

Usage

Least(<input>,…)

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.

NOTE: If you would like to compare a column of dates against a specific date, you must wrap the input in the Date() function.

Examples

Least([Date], Date(“2018-04-12”))
  • Returns the value in [Date] if the date is before April 12, 2018, otherwise it returns April 12, 2018. It is testing for the date that occurs the furthest back.
Least([Profit 2016], [Profit 2017], [Profit 2018])
  • Returns the profit numbers for the year that was a least profitable.

See Also

Min
Greatest

More About Math Functions

These functions return well-known mathematical constants or implement common arithmetic functions.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.