--- 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." tags: ["MAX", "Largest Value ", "functions ", "formula syntax", "Pigment Blocks", "Pigment Boards", "Modeling and Formulas"] updated: 2025-05-30T09:40:56Z published: 2025-08-22T10:57:28Z canonical: "kb.pigment.com/max-function-numeric" --- > ## 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!