Forum Discussion
Cumulative/Running Total
I think I've stumbled on the issue but not sure how to correct. When I use the Date slider visual and set it to beginning of FY (June 1 2019) and End date (Dec 31 2019) the Cumulative total works.However, when I use the date dropdown visual it does not. It looks like when I use the date dropdown visual and select July the Date Min is 7/1 and Date Max is 7/31. See below both ways that I've tested this.
1st image
2nd Image
My question is without using the date slider visual how do i get the Cumulative Measure to look back at past months from the current month that I select. The first image is displaying the correct information.
Hi jake223
this depends on your measures and data model.
If you've used "ALLSELECTED" somewhere in your measure-chain, this would be the expected behaviour:
Your slicers return different things: The first returns a range of periods and the secod one just one period. So you should expect different results.
I would recommend to start to create a mockup file that you can share here. This might help you in debugging the business logic you've used and narrow down the current culprits in your model.