Forum Discussion
Solved
Cumulative sum
Hello experts:
I have calculated Cumulative sum using DAX
Everything is working fine but if for particular year if we have blank then graph is not showing cumulative sum it’s just showing blank only.
For example:
for Year 2022 sales is blank and for 2021 year sales is 10k
And for 2023 yeat sales is 20k
So ideally graph should show 2021 total sales 10K
2022 total sales 10k
And 2023 total sales 30 k
But it’s showing 10k, zero and 20 k respectively
Any idea?
Jay2639 This works with the data you shared:
Cumulative Sales =
CALCULATE (
SUM ( Sales[Sales] ),
FILTER ( ALL ( Sales[Year] ), Sales[Year] <= MAX ( Sales[Year] ) )
)
1 Reply
Jay2639 This works with the data you shared:
Cumulative Sales =
CALCULATE (
SUM ( Sales[Sales] ),
FILTER ( ALL ( Sales[Year] ), Sales[Year] <= MAX ( Sales[Year] ) )
)