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.