Forum Discussion
Reverse Cumulative Total not working for summarized data(Sum)
Here i am not using Date column ! I need rever **bleep** value for Revenue based on Column Cutomer_Code and not Date!
It is working for "Dont Summarize", but when i summarize Revenue as Sum, it gives Wrong Value.
code :
cum_temp =
VAR RunningTotal= CALCULATE([sum_of_reven], FILTER(ALL(Underlying_Cargo_Analysis[Revenue]), Underlying_Cargo_Analysis[Revenue]>=MIN(Underlying_Cargo_Analysis[Revenue])))
RETURN
IF(ISBLANK([sum_of_reven]),BLANK(),RunningTotal)
No RepliesBe the first to reply