Forum Discussion
Calculate Rolling Average with Consideration to Data Preceding Date Slicer Selection
Hi, I am looking to calculate the 12 month rolling average value for some sales/material data that I have. Currently, my 12 month rolling average calculation is working, but it only takes into ac...
amitchandak
Super User
Super Userbbzzbb809 , try a measure like
12 Month Avg = CALCULATE(AverageX(Values('Date'[MONTH Year]),calculate(Sum('Table'[Value])))
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))