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...
Hi Amit,
Thank you for the response. I just tried using this measure, but it is still running into the same issue as my "_12months rolling average: based on max date of range" in that it doesn't take into account the data preceding the date slicer selection for the rolling average calculation.