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...
Hi Anonymous ,
I have done a similar thing. Have a look at the below and let me know if it solves your issue. ( it might need some adaptation).
1.Create a calculated table with the dates that will be used as a slicer
SlicerTable = VALUES(SourceTable[Date])
2.Do a measure in your IDs table.
12MonthsAverage =
VAR SelectedDate = SELECTEDVALUE(SlicerTable[Date])
VAR CurrentDate = SELECTEDVALUE(IDsTable[Date])
RETURN IF(CurrentDate <= SelectedDate &&
CurrentDate > EOMONTH(SelectedDate,-12),
Count(IDsTable[CaseId]),0)