Forum Discussion

heo_Seeland's avatar
heo_Seeland
Frequent Visitor
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI heo_Seeland,

     

    Can you please share some detail contents about your issue?

     

    Regards,
    Xiaoxin Sheng