Table.Max

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

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  

ArgumentDescription
tableThe Table to check.
comparisonCriterialargest row or rows comparison criteria.
optional defaultDefault value.

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

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

NameJeff
Level10
Salary200000
Show: