Running total or Cummulative sum DAX

[sanchar123]

@amitchandak 

I have a problem performing cummulative sum/ running sum on one of my columns.

 

Can you help me 

Thanks in advance

[amitchandak]

@sanchar123 , A new column

sumx(filter(Table, [Date and time] <= earlier([Date and time] )),[E1 electical meter])

A new measure

sumx(filter(allselected(Table), [Date and time] <= max([Date and time] )),[E1 electical meter])

[sanchar123]

@amitchandak  appreciate your quick help.

I am caught in the loop, while executing the query.

WOndeirng if this cummulative type of calculation  decrese the performance when I am refreshing the data at Desktop level. 

What can be the solution, running in the Power BI Services? dataflows?

I 

[amitchandak · Accepted solution]

@sanchar123 , yes,  cumulative as big cost. So see if the measure can work