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

amitchandak's avatar
amitchandak
Super User
6 years ago

Try for the future month as 0

DI Impact Actual Running Total = CALCULATE(
                  SUM ('DI Impact'[DI Impact]),
                  FILTER (
                    ALL ('DI Impact'),'DI Impact'[DI Impact Date] <= MAX ('DI Impact'[DI Impact Date])
					&& 'DI Impact'[DI Impact Date] <=today()
                  && 'DI Impact'[DI Impact Type]="Actual"
)
)


Or 

DI Impact Actual Running Total = CALCULATE(
                  SUM ('DI Impact'[DI Impact]),
                  FILTER (
                    ALL ('Date'),'Date'[Date] <= MAX ('DI Impact'[Date])
					&& 'Date'[Date]<=today()
					)
                  ,'DI Impact'[DI Impact Type]="Actual"

)
Anonymous's avatar
Anonymous
Not applicable
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