ModeIf

Gets the most common value in the column filtered by the condition

ModeIf(colum1, colum2 > colum1) → 5
ModeIf(colum2, Startswith(colum3, "A")) → 10

Inputs

ModeIf(column, [condition])

  • column - A column to get the mode value for

  • [condition] - [optional] - Condition to filter values in the column