Forum Discussion

JB_AT's avatar
JB_AT
Helper III
2 years ago

Get Cumulative Value

I followed this brilliant video from AlbertoFerrari  and the functionality works as expected. Where I am struggling is instead of showing the last 6 months and the values in those months, how can I modify the measure to show the cumulative amount instead?

Below is the measure I currently have, but i would like to change it to show the result cumulatively

 

Thanks

Sales P12M = 
VAR RefDate = MAX(DIM_Date[Date])
VAR PrevDate = DATESINPERIOD(PresentationCalendar[Date], RefDate, -12, MONTH)
RETURN
CALCULATE (
    [Sales],
    REMOVEFILTERS( DIM_Date),
    KEEPFILTERS(PrevDate),
    USERELATIONSHIP(DIM_Date[Date], PresentationCalendar[Date]))

  

Need Help

2 Replies

  • JB_AT's avatar
    JB_AT
    Helper III
    2 years ago

    Instead of using the Sales measure, i used a last 12 months measure that I had created instead and got the result I needed

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi JB_AT ,

     

    Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.