Forum Discussion

PeterBI's avatar
PeterBI
Helper I
10 years ago

looking for a simple running Total solution

Hello, 

i'm looking for a simple solution to get the running total like this Excel Solution. Thanks in advance.

 

IndexSaldoRunning Total
100
2-87,5-87,5
3-225-312,5
4-237,5-550
5350-200
6-75-275
70-275
812,5-262,5
950-212,5
1012,5-200
11-12,5-212,5
1250-162,5
1337,5-125
14-150-275
15450175
16-15025
Need Help

13 Replies

    • PeterBI's avatar
      PeterBI
      Helper I
      10 years ago

      Thanks, i know your Site but every solution Group Data especially with the Date. I'm very Happy if there is a simple Way only maybe with the Index Row.

       

      And please don't forget, I'm new to BI, so the first Steps are a little bit bumpy ;-)

       

      Regards, Peter

      • Sean's avatar
        Sean
        Community Champion
        10 years ago

        PeterBI Try this! Just change the Table name

         

        Running Total = CALCULATE(SUM(Table[Saldo]), FILTER (ALL(Table[Index]), Table[Index] <= MAX (Table[Index]) ) )

         

        NOTE: Your table will HAVE TO BE SORTED by INDEX!

         

        EDIT: => Use ImkeF's answer below!