Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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], FILTER(All('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date])))
It interacts properly with a filter I have in this page and produces the expected chart:
The problem starts when I try to reverse the cumulative sum:
Reverse Acc Sales = CALCULATE([Sales], FILTER(All('Calendar'), 'Calendar'[Date] >= MIN('Calendar'[Date])))
Doing so I get values starting from the year 1987 and the chart gets really weird:
Any ideas on how to solve that?
Solved! Go to Solution.
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
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
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |