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 onl...
Jay2639 This works with the data you shared:
Cumulative Sales =
CALCULATE (
SUM ( Sales[Sales] ),
FILTER ( ALL ( Sales[Year] ), Sales[Year] <= MAX ( Sales[Year] ) )
)
Jay2639 This works with the data you shared:
Cumulative Sales =
CALCULATE (
SUM ( Sales[Sales] ),
FILTER ( ALL ( Sales[Year] ), Sales[Year] <= MAX ( Sales[Year] ) )
)
CALCULATE (
SUM ( Sales[Sales] ),
FILTER ( ALL ( Sales[Year] ), Sales[Year] <= MAX ( Sales[Year] ) )
)