The CumulativeMax function calculates the maximum of a column up to and including the current row value.



Function Arguments:

  • [Column] (required) - The column of numbers to evaluate the cumulative max.

Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.


CumulativeMax(\[Monthly Revenue\])

A table contains the monthly revenue for a store. The CumulativeMax function can be used to find the maximum monthly revenue up to and including the current month.

Related resources