MODE ​

Returns the most frequent occurring or repetitive value from a range of inputs.

MODE(input_a, input_b, ...input_n)

MODE(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 ​

MODE(["Measure A"], ["Measure B"], ["Measure C"], ["Measure D"])

MODE(["Measure A"], ["Measure B"], ["Measure C"], ["Measure D"])

Result: 3

Note: Assume the value held at Measure A is equal to 1 and the value held at Measure B and Measure C are equal to 3 and Measure D is equal to 8.