Cumulative chart

2

Hi @Daniel_Hollands1 and Welcome to the Community :partying_face: !

Is this what you were looking for ? :innocent:
(Look at the green line in the chart called [View of Data] in the sample down below :blush: )

If yes, the formula I used in the Data table (you’ll find below the chart) in the field called [Cumulative Usage Sum] is:

Data.Filter(
  Month <= thisRow.Month
).Usage.Sum()

(Note that Month is in fact CurrentValue.Month)

And what it does is :

  1. It takes the whole list of rows the Data table is and from that whole list of rows (each row in the list being stored as/represented by CurrentValue), I ask Filter() to only keep the rows where CurrentValue.Month is less or equal than the value in thisRow.Month… which returns a filtered list of rows.
  2. From the filtered list of rows, I can then dereference (access) their respective value in the field Usage transforming the list of rows in a list of numbers.
  3. Sum() the values in the list of numbers :blush: .

I hope this helps :innocent: !
Don’t hesitate if this is not what you wanted to accomplish (:sweat_smile: ) … or if you have questions :blush: