CumulativeMin
The CumulativeMin function calculates the minimum value of a column up to and including the current row value.
Syntax
CumulativeMin(\[Column\])
Function Arguments:
- [Column] (required) - The column of numbers to evaluate the cumulative minimum.
Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.
Example
CumulativeMin(\[Monthly Revenue\])
A table contains the monthly revenue for a store. The CumulativeMin function can be used to find the minimum monthly revenue up to and including the current month.
Updated 4 months ago
Related resources