Forum Discussion
Solved
Cumulative sum by columns
I have a table REQ in which I want to count values each day and show in a graph the cumulative sum, I used measure Acumulate = CALCULATE(count(Reqs[ID]),FILTER(ALLSELECTED(Reqs),Reqs[DAY]<=MAX(R...
Hi nranito,
Do you want to get a output like below? Calculate the cumulative sum of Sales per day and group by Type.
If it is, you could refer to this measure.
Measure 2 = CALCULATE ( SUM ( Table1[Sales] ), FILTER ( ALLEXCEPT ( 'Table1', Table1[Type] ), 'Table1'[Day] <= MAX ( 'Table1'[Day] ) ) )If not, please share your data sample which could reproduce your scenario and your desired output.
Best Regards,
Cherry
It's just that, thank you!
Can you explain what "allexcept" does? I tried, as you pointed, using GROUP BY, with no success...
Hi nranito,
You could have a view of AllEXCEPT function which introduce how to use it in more details.
Best Regards,
Cherry