Description
Returns the largest value among all given values. Data type be numeric or date.
Syntax
MAX(Value1 V, Value2] a, Value3] …)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Value1 (required) | Integer, Number, or Date | Any Dimensions | First value to compare. |
| Value2 (optional) | Integer, Number, or Date | No Dimension or Dimensions of argument Value1 | Other value to compare. |
| Value3 (optional) | Integer, Number, or Date | No Dimension or Dimensions of argument Value1 | Other value to compare. |
| This functions accepts any number of arguments of the same data type as the Value1 | |||
Returns
| Type | Dimensions |
|---|---|
| Integer, Number, or Date | Dimensions of argument Value1 |
Examples
| Formula | Result | Description |
|---|---|---|
MAX(5, 1.1, 3) | 5 | 5 is the largest value. |
MAX(-14.7, 34) | 34 | 34 is the largest value. |
|
| Returns the largest value between the Metric | |
Max('Start Date',DATE(2023,1,1)) | Returns the latest date between the Metric Start Date and January 1st 2023, thus replacing any dates before January 1st 2023 with January 1st 2023 |
See also
Excel: MAX
Related articles: MIN
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
