Forum Discussion
Cumulative Balance Issue
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
)
RETURN
CALCULATE (
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:
https://drive.google.com/file/d/1LcEYNZFgxKRLDbOZelNYltgxBmmg6buA/view?usp=sharing
Anonymous , I think across tables data is not getting added up in the context so forced that in suggested formula
3 Replies
Anonymous , Try like
Cumulative Balance Updated = VAR Result = CALCULATE ( sumx(SUMMARIZE('Date','Date'[MonthnYear],"_1",[Balance Current Month Updated]),[_1]), FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] <= MAX('Date'[Date] ) )) RETURN ResultAnonymous , I think across tables data is not getting added up in the context so forced that in suggested formula