Select Page

Returns the largest value amongst the inputs.


Greatest(<input 1>, <input 2>…)

input 1 (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.


Greatest([Profit 2018], [Profit 2017], [Profit 2016])
  • Returns the profit from the year with the greatest profit
Greatest([Invoice Date], Date(“2018-01-01”))
  • Returns the more recent date.

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.