List.Max Function in Power Query
The List.Max function returns the maximum item in a list, or the optional default value if the list is empty.
Syntax
List.Max(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as any
Example: Find the max in the input list.
Power Query M
let Source = List.Max({100, 400, 700, 300, -200, 500}) in Source
The output of the above code is 700.