cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mthsdiniz Frequent Visitor
Frequent Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
d_gosbell Senior Member
Senior Member

Re: Help while summing earlier values in a line graph

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 1
d_gosbell Senior Member
Senior Member

Re: Help while summing earlier values in a line graph

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.