[Help] Reverse Cumulative Total

[snamhoang]

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)

[CheenuSing]

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

[v-ljerr-msft]

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).

Cumulation Column = 
VAR currentDate = Table1[date]
RETURN
    CALCULATE (
        SUM ( Table1[item] ),
        FILTER ( ALL ( Table1 ), Table1[date] >= currentDate )
    )

Regards