Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Running Total - Cumulative

Hi. I am trying to build a running total on my query, but on the Advanced Query Editing rather than on DAX, given the type of data. The data is fragmented and I'd rather do it using Query. Does any...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Anonymous

     

    Since we don’t know the structure of your data table, I’ll give you a reference. Please refer to this link, there is a working solution which can be downloaded. Hope it helps.

     

    Best Regards,

    Herbert

     

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Anonymous

 

Since we don’t know the structure of your data table, I’ll give you a reference. Please refer to this link, there is a working solution which can be downloaded. Hope it helps.

 

Best Regards,

Herbert

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymous v-haibl-msft

     

    Thanks for your replies. Let me explain. The data preview is below.

     

     

    So my goal is to have per day and per atribute (F1 or F2) the running total. I said that the data is fragmented because it comes from 3 different sources. Because of this constraint, this running total starts at 129960.89 for F1 and 24638.63 for F2. Also, for F1 at 18/10/2016 the total should restart.

     

    I tried the model you sent but I couldn't figure out how to apply it to my case.

     

    Could you help with this info?

     

    Probably I am a bit lost so sorry for that.

     

    Thanks in advance for your help.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I grouped the data by attribute and I could solve the problem!

     

    Thanks! :smileyvery-happy: