I wanted to perform a SUM on all measures where the data is less than/equal to the current rows date. For example,
Category | Date | Benefits $ | Calculated SUM | ||
A | 06/08/2020 | 5 | 25 | ||
A | 06/09/2020 | 10 | 35 | ||
A | 06/10/2020 | 15 | 50 | ||
A | 05/02/2020 | 10 | 10 | ||
A | 06/01/2020 | 10 | 20 |
Solved! Go to Solution.
The Running Total tool may also be of interest if your dates are already sorted in the order that is desired. This sums up a column of data within the group specified.