Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running total modification

Hi PowerBI community, First off, I hope you are all well and safe in these challenging times.   I was hoping some of you might be able to assist me with a working "running total" formula that I ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi all,

     

    Unfortunately none of these solutions worked 😞 What I ended-up doing:

     

    • future month as blank: I gave up
    • only suming the first line against a repetitive month: I moved the columns in a separate column with no repeats and applied a simple running total measure and created a relationship back to the first table.

    THanks all for trying to help 🙂

    OF

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi camargos88 , do you suggest I use this formula for my first or second problem? I'm trying to convert it to make it work 🤔

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Anonymous ,

 

The second one, this formula handles the duplicated value.

 

Ricardo

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Unfortunately it still sums everything up for the same month, although only for previous months, not future. Did I do something wrong:

     

     

    DI Target Running (test) = CALCULATE(
                  SUMX('DI Impact','DI Impact'[DI Target.DI Target Amount] / CALCULATE(COUNT('DI Impact'[DI Impact Date]))),
                  FILTER(ALL('DI Impact'[DI Impact Date]),'DI Impact'[DI Impact Date] <= MAX('DI Impact'[DI Impact Date])))