Select Page

Returns the smallest value amongst the inputs.



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.


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


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.