Forum Discussion

Ardietrinidad's avatar
Ardietrinidad
Frequent Visitor
7 years ago

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