Forum Discussion

blackgold's avatar
blackgold
Regular Visitor
3 years ago

Daily Values from Running Total

Hello,

 

I am attempting to get daily values from the running total.
I have three columns Key, Date, Cumulative Cases. I am trying to get the daily values per key.

I have attached a picture from excel of what i am trying to do in PowerBI. However, I can not do it on excel because the data has over 3 million rows. 

 

Keeping the performance in mind, which will better DAX or power query?

 

Update

I have come up with a solution which works with a sample dataset but when I try it with the actual dataset the DAX formula stays on "working on it".

 

I appreciate the help.

Thank you!

 

 

 

Need Help

8 Replies

    • blackgold's avatar
      blackgold
      Regular Visitor
      3 years ago

       

      KeyDateCumulative Cases
      Baldwin, Alabama4/10/202264
      Baldwin, Alabama4/11/202270
      Baldwin, Alabama4/12/202275
      Baldwin, Alabama4/13/202282
      Autaga, Alabama4/10/202218
      Autaga, Alabama4/11/202219
      Autaga, Alabama4/12/202219
      Autaga, Alabama4/13/202220
      Tyler, Texas4/10/202287
      Tyler, Texas4/11/202289
      Tyler, Texas4/12/202295
      Tyler, Texas4/13/2022102

       

      • blackgold's avatar
        blackgold
        Regular Visitor
        3 years ago

        Hello VahidDM,

        I have updated the question. 
        I come up with solution but it is only working on the sample dataset. When I use the same DAX formula on the actual dataset, PowerBI is stuck on working on it. 
        What will suggest on optimizing the DAX formula?
        Thank you!