Forum Discussion
Help while summing earlier values in a line graph
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.
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.
1 Reply
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.