Forum Discussion

dougzecpier's avatar
dougzecpier
New Member
4 years ago
Solved

Reverse cumulative sum

Dear all,   I am trying to make a reverse cumulative sum but I am getting an unexpected result. I started with the rationale of the cumulative sum, and it works fine: Acc Sales = CALCULATE([Sales...
  • Shaurya's avatar
    Shaurya
    4 years ago

    Hi dougzecpier,

     

    The following formula works for me:

     

    Sum = CALCULATE(SUM('Table'[Values]),FILTER(ALL('Calendar'),'Calendar'[Date]>=MIN('Calendar'[Date])))

     

     

    Make sure that the join between your Calendar and Values Table is One to Many and has a single direction filter.

     

    Did I answer your question? Mark this post as a solution if I did!
    Consider taking a look at my blog: Forecast Period - Previous Forecasts

Shaurya's avatar
Shaurya
Icon for Memorable Member rankMemorable Member
4 years ago

Hi dougzecpier,

 

The following formula works for me:

 

Sum = CALCULATE(SUM('Table'[Values]),FILTER(ALL('Calendar'),'Calendar'[Date]>=MIN('Calendar'[Date])))

 

 

Make sure that the join between your Calendar and Values Table is One to Many and has a single direction filter.

 

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts