The Median function finds the mathematicalΒ median of a column or group.

Syntax

Median(numbers)

Function arguments:

  • column (required) - The column of numbers to be evaluated.

πŸ“˜

If there is an even number of values, Median will interpolate between the middle values.

Example

Median(\[Temperature\])

Find the median temperature value. If the column values are 3, 5, 7 and 20 the result would be 6.