Forum Discussion
Helper VHaving trouble getting a rolling sum to work properly
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]))
Helper V
Attached is a link to a file with more test data. You can see what I'm after on the summary tab. I really just need a rolling figure. I can get it to work except for the rolling % piece.
Helper VThis actually works (the blue highlighted) but I need to get it to work when different industries are selected..
- Zarlot531
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]))