MaxIf

Gets the maximum value in the column filtered by the condition

MaxIf(column1, column2 > 20) → 50
MaxIf(column1, EndsWith(column2, "3")) → 41

Inputs

MaxIf(column, [condition])

• column - A column to calculate the maximum value for

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