Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.Max

Owen Duncan|Last Updated: 4/19/2018

About

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

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

Arguments

ArgumentDescription
tableThe Table to check.
comparisonCriterialargest row or rows comparison criteria.
optional defaultDefault 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]  
NameJeff
Level10
Salary200000
© 2018 Microsoft