---
title: "MAX function (Numeric)"
slug: "max-function-numeric"
description: "Learn to apply the MAX function in Pigment to return the highest value across multiple inputs, whether numbers or dates."
updated: 2025-05-30T09:40:56Z
published: 2025-08-22T10:57:28Z
---
> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.
# MAX function (Numeric)
## Description
Returns the largest value among all given values. Data type can be numeric or date.
## Syntax
`MAX(Value1 [, Value2] [, 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. |
| `MAX('Quantity', 0)` | | Returns the largest value between the Metric `Quantity` and 0, thus replacing negative values by 0. |
| `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](https://support.microsoft.com/en-us/office/max-function-e0012414-9ac8-4b34-9a47-73e662c08098)
Related articles: [MIN](/v1/docs/min-function-numeric)
> [!TIP]
> 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!