`NARY_MAX` is similar to `MAX`, except that it lets you compare multiple values.

## Sample usage

`NARY_MAX(Event_1, Event_2``, Event_3)`

## Syntax

    NARY_MAX(X, Y, [,Z]*)

### Parameters

- `X, Y, Z` - fields or expressions to be evaluated.

## Example 1

This example shows how you can mix fields, calculations, and literals in an `NARY_MAX` function:

`NARY_MAX(REVENUE, (COST * 2), 10, SESSIONS))`

## Example 2

Suppose you want to determine the maximum sales for your 3 sales regions by date and that your data looks like this:

|---|---|---|---|
| Date | Region 1 Sales | Region 2 Sales | Region 3 Sales |
| Date 1 | 100 | 200 | 150 |
| Date 2 | 75 | 130 | 150 |
| Date 3 | 225 | 185 | 230 |

You could use the `NARY_MAX` function to determine the maximum sales for a given date:

| Example formula | Date | Output |
|---|---|---|
| ` NARY_MAX(Region 1 Sales, Region 2 Sales, Region 3 Sales,) ` | Date 1 | 200 |
| ` NARY_MAX(Region 1 Sales, Region 2 Sales, Region 3 Sales,) ` | Date 2 | 150 |
| ` NARY_MAX(Region 1 Sales, Region 2 Sales, Region 3 Sales,) ` | Date 3 | 230 |

## Notes

`NARY_MAX` requires at least 2 arguments. At least one argument must be a field or an expression containing a field.

`NARY_MAX` works on numeric fields or expressions only. If you apply this function to other data types, you'll get an error.

## Related resources

- [NARY_MIN](https://docs.cloud.google.com/data-studio/narymin)
- [Calculated fields](https://docs.cloud.google.com/data-studio/about-calculated-fields)
- [Data Studio function list](https://docs.cloud.google.com/data-studio/function-list)