Forum Discussion
Cumulative balance / running total issue
Hi experts,
I am new in power BI and would really need your help. I have a report which has a selection criteria of Year & Months based on the date table. Now, my problem is when I select e.g. Year = 2019 & month = May, I'd like to have a running total from Jan to May although I only selected the month of May. Please find current formula I made below.
1. ) Actual_CumBase = TOTALYTD(sum(Q_Budget_Actual_Report[Eur_Actual]),Dates[Date])
2.) Actual_Cummulative = calculate(
[Actual_CumBase],
filter(
ALLSELECTED(Q_Budget_Actual_Report),
Q_Budget_Actual_Report[PostingDate]<=max(Q_Budget_Actual_Report[PostingDate])
)
)
3 Replies
- Greg_Deckler
Community Champion
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008 - v-jiascu-msft
Microsoft Employee
- ArdietrinidadFrequent VisitorHi, my issue still open. I could not resolve it from the suggested solution. I’m still hoping somebody can help me out about this issue.