List.Min
Returns the minimum value or the default value for an empty list.
function (list
as list, optionaldefault
as nullable any, optionalcomparisonCriteria
as nullable any, optionalincludeNulls
as nullable any) as nullable any
Returns the minimum item in the list
list
, or the optional default value default
if the list is empty. An optional comparisonCriteria value, comparisonCriteria
, may be specified to determine how to compare the items in the list. If this parameter is null, the default comparer is used.List.Ordering
Find the min in the list {1, 4, 7, 3, -2, 5}.
List.Min({1, 4, 7, 3, -2, 5})
-2
Find the min in the list {} or return -1 if it is empty.
List.Min({}, -1)
-1
Last modified 4yr ago