Forum Discussion

sanchar123's avatar
sanchar123
Helper I
5 years ago
Solved

Running total or Cummulative sum DAX

amitchandak 

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

 

Can you help me 

Thanks in advance

 

Need Help DAX

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      sanchar123
      Helper I
      5 years ago

      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