List.Min

 

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 minimum item in a list, or the optional default value if the list is empty.

List.Min(list as list, optional default as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as any  

ArgumentDescription
listThe List to check.
optional defaultThe default value to return.
optional comparisonCriteriaSpecifies how to compare values in the list. If this argument is null, the default comparer is used.
optional includeNullsThe Logical value whether or not to include null values in the return list.
List.Min({1, 4, 7, 3, -2, 5}) equals -2  

Show: