Max

The Max function finds the maximum value for a column or group.

📘

The Max function is an aggregate function.

Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see Group columns in a table.

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see Add summary statistics to a table.

To learn more about using aggregate functions, see Building complex formulas with grouped data.

Syntax

Max(field)

Function arguments:

• field (required) - The column to be searched.

Notes

• The field argument must be a value with the Number, Date, or Text data type.

Examples

Max([Distance])

• In a table summary, returns the greatest Distance across all rows in the table.
• In a calculated column in an ungrouped table, returns each row's own Distance value.
• In a table grouped by Airline, returns the greatest Distance for each airline.

Max([Invoice Date])

When used in a table summary, returns the greatest invoice date, which is the most recent date in the [Invoice Date] column.

Max([Name])

When used in a table summary, returns the name that is alphabetically last from the [Name] column.

GrandTotal(Max([Cost]))

When used in a calculated column in a table, returns the greatest cost from the [Cost] column in each row.