Forum Discussion

mthsdiniz's avatar
mthsdiniz
Frequent Visitor
7 years ago
Solved

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 ...
Need Help
  • d_gosbell's avatar
    d_gosbell
    7 years ago

    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.

d_gosbell's avatar
d_gosbell
Super User
7 years ago

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.