Max

The MAX function returns the largest value among the specified numbers.

This function is used to find the maximum value from a list of numbers.

Syntax:
MAX(number1, [number2], …)

Find the Largest Value in a Field:
```
MAX(#[Exceptions].[Duration])
```
Returns the maximum value from the Duration field in the linked Exceptions records.
Find the Maximum Overdue Days:
```
MAX(FILTER(#[Actions].[Days Overdue], #[Actions].[State] = "Overdue"))
```
Returns the maximum value from the Days Overdue field in the linked Actions records, where the State is "Overdue."

Argument	Data Type	Description
number1	Number / Number Array	The first number to compare.
*[number2]*	Number / Number Array	(Optional) Additional numbers to compare.

Type: Number