rollingsum
1 Topic
Rolling sum for last 3 months giving same value as current month
Hi I'm trying to achieve rolling sum for last 3 months from my current record. I have sample data like below State | Town | Block | Period | Consumption A | a1 | ab1 | 10/1/2022 | 100 A | a1 | ab1 | 11/1/2022 | 102 A | a1 | ab1 | 12/1/2022 | 150 A | a1 | ab2 | 11/1/2022 | 101 B | b1 | bb1 | 12/1/2022 | 103 B | b2 | bb3 | 9/1/2022 | 110 for one particular block, i need to calculate last 3 months rolling consumption or rolling avg consumption However when i used this formula CALCULATE ( SUM ( summaryPriorDataAnalysis[consumption] ), DATESINPERIOD ( 'summaryPriorDataAnalysis'[PERIOD], MAX ( summaryPriorDataAnalysis[PERIOD] ), -12, MONTH ) , i get same value as current consumption record. Please help? For each record i need to get it's three months consumption sum. NOTE: the period column is not unique,Solved970Views0likes5Comments