Forum Discussion
quick measures Rolling Average ERROR
Hi Guys,
i get this error when i try to create a Rolling average with quick measures
Working Capital rolling average 2 =
IF(
ISFILTERED('Calendar'[Date]);
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column.");
VAR __LAST_DATE = ENDOFMONTH('Calendar'[Date].[Date])
VAR __DATE_PERIOD =
DATESBETWEEN(
'Calendar'[Date].[Date];
STARTOFMONTH(DATEADD(__LAST_DATE; -12; MONTH));
ENDOFMONTH(DATEADD(__LAST_DATE; 1; MONTH))
)
RETURN
AVERAGEX(
CALCULATETABLE(
SUMMARIZE(
VALUES('Calendar');
'Calendar'[Date].[Year];
'Calendar'[Date].[QuarterNo];
'Calendar'[Date].[Quarter];
'Calendar'[Date].[MonthNo];
'Calendar'[Date].[Month]
);
__DATE_PERIOD
);
CALCULATE([Working Capital]; ALL('Calendar'[Date].[Day]))
)
)
1 Reply
- AnonymousNot applicable