Forum Discussion
Zarlot531
Helper V
Helper VHaving trouble getting a rolling sum to work properly
I have a dataset that provides "Starting RMR" (RMR is recurring monthly revenue) by year but then also shows the first cancellation by year. So in the pivot below I have RMR by start year going acros...
In the Dax formula below/second image below you'll see *a* solution. Not sure if it's the best one. But there's another weird problem. The Pivot Table doesn't sum the row grand totals of the rolling measure properly, even though everything else is summed and rolls properly within the columns. See first image below. The row grand total takes only the latest in the row into of summing it. Hmm.
=calculate(sum([First Cancel RMR]),filter(allselected('Range'),Range[First Cancel Year]<=max([First Cancel Year]) && max(Range[StartYear]) = 'Range'[StartYear]))
PaulDBrown
Community Champion
Community ChampionPlease provide sample data in a tabular structure (not an image) or sample PBIX file & a depiction of the expected outcome (from Excel for example)
Zarlot531Helper V
Helper VI think I'm getting close with this... it's rolling, just rolling too much. need to add some more filter.