Forum Discussion
Cumulative formula error
im using this cumulative formula ---- Cumulative_orders = calculate(SUM('New folder'[quantity]),FILTER(all('New folder'[orderDate]),'New folder'[orderDate]<=(1+MAX(('New folder'[orderDate]))))) but the cumulative column is returning same values and not sum that 1,2,8, 10 is returning as 1,2,8,10 but not 1,3,11,21
DAX - Cumulative count for only active customer
2 Replies
Hi RiddhimaC
You can get your required output in the following way, for example.
An example pbix file is attached below.
Best regards,
nope no luck, still the same. Not sure where Im going wrong. I combined and loaded 3 files from a folder BTW and then sorted ACC to date...
