Help while summing earlier values in a line graph

[mthsdiniz]

Good Afternoon,

I have the following volumes in the given times:

09:30:00 = 5000

09:45:00 = 100

10:00:00 = 1000

I want to display this values as an aggregation of the actual value with the earlier value, being this way>

09:30:00 = 5000

09:45:00 = 5100

10:00:00 = 6100

and so on ...

Is that possible?

Ps: my time value is a string value.

[d_gosbell · Accepted solution]

That looks like a simple cummulative sum. A calculation like the following should work: 

Cummulative Volume = CALCULATE( SUM(table1[Volume]) , FILTER( All( table1[Time] ), table1[Time] <= MAX( table1[Time] ) )

I'm not sure if you can do MAX over string values, this used to be an issue in earlier versions of the engine. If so you may need to convert your time to a datetime data type.