Table of contents
TOC
Collapse the table of content
Expand the table of content

List.Median

Owen Duncan|Last Updated: 4/19/2018

List.Median(list as list, optional comparisonCriteria as any) as any

About

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.

Example 1

Find the median of the list {5, 3, 1, 7, 9}.

List.Median({5, 3, 1, 7, 9})

5

© 2018 Microsoft