Rolling sum across categories that are not dates

Sometimes you may need to create a PowerPivot report that displays rolling totals on categories that do not reflect years, months or days. You might feel a bit stuck as most of the examples on rolling aggregates are related to time, for example Year to Date figures. Those can be implemented using DAX functions like TOTALYTD(), but as you examine the required parameters for that function you discover that a date column is necessary.