Forum Discussion
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 ...
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 , thank you for the suggestion. You actually gave me the idea to further amend the formula to be more precise.
Unfortunately it still shows numbers for months in the future whereas I was hoping to show "null"
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"
)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