---
title: MAX
description: Discover the syntax, parameters, and practical examples for calculating maximum values across dates, strings, and numbers.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# MAX

 The MAX function in Infoveave finds the maximum (largest) value in a specified column (Measure).

## Applicable to

* Calculated Columns
* Expressions

## Return Value

* The largest value in the specified column.

## Remark

* MAX is useful for identifying the maximum value in a dataset (e.g., highest sales, longest duration).
* MAX returns the maximum value, excluding nulls and blanks.
* MAX can be used with Dates, Strings, and Numbers.

## Syntax

```
MAX(<expression>)
```


<Aside type="tip">
*With a date column, MAX returns the latest date.
*With string values, MAX returns the last value alphabetically.
*With Booleans, MAX returns TRUE.
</Aside>

## MAX in Board Expression

<Aside>
Expressions add visual effects to your dashboard via widget-specific conditions. They don't manage or modify data.
</Aside>

**Parameters**

| Parameter     | Description                                                                                  |
|---------------|----------------------------------------------------------------------------------------------|
| Expression    | Placeholder replaced with actual widget and measure names.                                   |
| Widget Name   | Specific name of the widget used for data visualization in the Infoboard.                   |
| Measure       | Name of the measure displayed or analyzed using the widget.                               |

<Steps>
1. Write the MAX function  `MAX(<expression>)`
2. Replace `<expression>` with `'Widget Name'[Measure]`
3. Replace **Widget Name** with your widget's name and **Measure** with the measure name.
4. For configuring Expressions in Infoveave, see [Configure Expression](/insights-v8/advanced-configuration/#configuring-expressions).
</Steps>

## MAX in Calculated Columns


| Parameter     | Description                                                                      |
|---------------|----------------------------------------------------------------------------------|
| Expression    | Placeholder replaced with column names.                                           |
| Column Name   | Name of the column containing the values you want to analyze.                     |

<Steps>
1. Write the MAX function `MAX(<expression>)`
2. Replace `<expression>` with `[Column Name]` in the dataset.
3. For using Infoveave functions in calculated columns, see [Add Calculated Column](/studio-v8/datasources/calculated-columns-datasource/) under Sources.
</Steps>

**Example**

**Scenario** Finding the maximum product price (under 100) on an e-commerce platform.

**Scenario Details**

* **Dashboard Name** E-commerce Bargain Finder
* **Widget Name** Product Prices
* **Measure Name** Price

**Objective** Find the maximum price and check if it exceeds 100.

```
MAX('Product Proces'[Price]) <= 100
```

**Example**

**Objective** Find the maximum "UNIT PRICE" in a sales dataset.

| ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY |
|---|---|---|---|---|---|
| 2024-01-03 | Brazil | Baby Food | 38.41 | 43.7874 | 2 |
| 2024-01-07 | Japan | Spices | 45.56 | 50.8155 | 20 |
|  | Japan |  |  | 43.7874 | 10 |
| 2024-01-18 |  |  |  | 32.3019 | 4 |
| 2024-01-22 | Brazil | Cosmetics | 28.335 | 23.0109 | 7 |
| 2024-01-26 | Canada |  | 20.185 | 23.0109 | 9 |
| 2024-01-04 | France | Cereal | 25.26 | 28.7964 | 9 |
| 2024-01-09 | Brazil | Cereal | 44.575 | 50.8155 | 8 |
| 2024-01-14 | Brazil | Snacks | 20.185 |  | 4 |
|  | Brazil | Cosmetics | 40.485 | 46.1529 | 2 |

```
MAX([UNIT PRICE])
```

The calculated column "Max Unit Price" will return 45.56.

| ORDER DATE | COUNTRY | CATEGORY | UNIT PRICE | MARKET PRICE | QUANTITY | MAX UNIT PRICE |
|---|---|---|---|---|---|---|
| 03-01-2024 | Brazil | Baby Food | 38.41 | 43.7874 | 2 | 45.56 |
| 07-01-2024 | Japan | Spices | 45.56 | 50.8155 | 20 | 45.56 |
|  | Japan |  |  | 43.7874 | 10 | 45.56 |
| 18-01-2024 |  |  |  | 32.3019 | 4 | 45.56 |
| 22-01-2024 | Brazil | Cosmetics | 28.335 | 23.0109 | 7 | 45.56 |
| 26-01-2024 | Canada |  | 20.185 | 23.0109 | 9 | 45.56 |
| 04-01-2024 | France | Cereal | 25.26 | 28.7964 | 9 | 45.56 |
| 09-01-2024 | Brazil | Cereal | 44.575 | 50.8155 | 8 | 45.56 |
| 14-01-2024 | Brazil | Snacks | 20.185 |  | 4 | 45.56 |
|  | Brazil | Cosmetics | 40.485 | 46.1529 | 2 | 45.56 |