Forum Discussion
[Help] Reverse Cumulative Total
Hi Guys,
Im trying to created a reverse comulative column on the right side but I want it to start from smallest as to day and become bigger when looking back to the past.
E.g. (increase from top to bot)
anyone has good solution for this? as I can only create the acumulation from 3 -> 10 (date), not from 10->3 (date)
2 Replies
v-ljerr-msftMicrosoft Employee
Hi snamhoang,
According to your description above, you should be able to use the formula below to create a calculate column to get the cumulation from 10->3 (date).:smileyhappy:
Cumulation Column = VAR currentDate = Table1[date] RETURN CALCULATE ( SUM ( Table1[item] ), FILTER ( ALL ( Table1 ), Table1[date] >= currentDate ) )Regards
Hi snamhoang
Please go through a solution atuhored by me.
http://community.powerbi.com/t5/Desktop/quot-Inverse-quot-Cumulative-Sum/m-p/72644#M30130
If this works for you please accept it as a solution and also givee KUDOS.
Cheers
CheenuSIng
