The CumulativeSum function calculates the sum of the input column up to and including the current row value.



Function Arguments:

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

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


CumulativeSum(\[Monthly Revenue\])

A table contains the monthly revenue of a store for the year 2022. The CumulativeSum function can be used to find the total yearly revenue up to and including that month. 

Related resources