Forum Discussion
JP-Siloam
4 years agoFrequent Visitor
Cumulative Sum with multiple slicer dates
I need to create two measures that each calculate the cumulative sum from the earliest data (date from will never change) up to user set dates. For the final result, I want a table that combines th...
- 4 years ago
Hi JP-Siloam , Try the attached solution. It uses disconnected date tables as the slicers. I've written the first measure as an example.
https://drive.google.com/file/d/10CZLxgMtiF47gwT3ctop6t0U_JgX6zqD/view?usp=sharing
Did I help you today? Please accept my solution and hit the Kudos button.
davehus
4 years agoMemorable Member
Hi JP-Siloam , Try the attached solution. It uses disconnected date tables as the slicers. I've written the first measure as an example.
https://drive.google.com/file/d/10CZLxgMtiF47gwT3ctop6t0U_JgX6zqD/view?usp=sharing
Did I help you today? Please accept my solution and hit the Kudos button.