Skip to content

MEDIAN

Returns the median of the given numbers. The median is defined as the central value within the set.

js
MEDIAN(input_a, input_b, ...input_n)
MEDIAN(input_a, input_b, ...input_n)

Parameters

  • input_a - Input to be evaluated.
  • input_b - Input to be evaluated.
  • input_n - Input to be evaluated. (optional)

Examples

js
MEDIAN(["Measure A"], ["Measure B"], ["Measure C"], ["Measure D"])
MEDIAN(["Measure A"], ["Measure B"], ["Measure C"], ["Measure D"])

Result: 2.5

Note: Assume values held at Measure A, Measure B, Measure C, Measure D, are 1, 2, 3, and 8 respectively.