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