Table.Max

About

Returns the largest row or rows from a table using a comparisonCriteria.

Syntax

 
Table.Max(table as table, comparisonCriteria as any, optional default as any) as any  

Arguments

Argument Description
table The Table to check.
comparisonCriteria largest row or rows comparison criteria.
optional default Default value.

Remarks

Table.Max is similar to List.Max but requires a table as input.

Example

Table.Max(Employees, "Salary") equals [Name="Jeff", Level=10, Salary=200000]  
Name Jeff
Level 10
Salary 200000