List.Median
Returns the median value in the list.
function (listas list, optionalcomparisonCriteriaas nullable any) as nullable any
Returns the median item of the list
list. This function returns null if the list contains no non-null values. If there is an even number of items, the function chooses the smaller of the two median items unless the list is comprised entirely of datetimes, durations, numbers or times, in which case it returns the average of the two items.List.Ordering
Find the median of the list
{5, 3, 1, 7, 9}.List.Median({5, 3, 1, 7, 9})
5
Last modified 4yr ago