Forum Discussion
12 Months rolling average
Hello Community, I hav a table (Case) with : 1. Case ID 2. Casedatevalue which contains date and is of date type I want to have count of case id by month and also rolling average for 12 mon...
I need to have the rolling 12 month rolling average.I need to use casedatevalue as a slicer and when I select year for ex 2023. It should do the 12 month rolling average from the selected year i.e in this case 2023 and the current month. Example : If I select 2023 from slicer, it should do the rolling average from the current selected year taking into account the current date/month.