I want the Cumulative Balance Updated column to be the cumulative of Balance Current Month Updated
The below formula is not working:
VAR Result_in =Total+ IF (Total < 0,Total * -1)RETURNCALCULATE (Result_in,FILTER ( ALLSELECTED( ( ‘Date’ )), ‘Date’[Date] <= MAX ( ‘Date’[Date] ) ))
Also the below is not working
Cumulative Balance Updated =CALCULATE ([Balance Current Month Updated],FILTER ( ALLSELECTED( ( ‘Date’ )), ‘Date’[Date] <= MAX ( ‘Date’[Date] ) ))
Link to pbix:
Go to Solution.
@AnuTomy , I think across tables data is not getting added up in the context so forced that in suggested formula
Proud to be a Super User!
View solution in original post
@AnuTomy , Try like
Cumulative Balance Updated =
VAR Result =
sumx(SUMMARIZE('Date','Date'[MonthnYear],"_1",[Balance Current Month Updated]),[_1]),
FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] <= MAX('Date'[Date] )
Thanks, that works ! But why was my formula not working?
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.