Slicer dates not correctly filtering measures such as 30 day rolling average

[RogerSteinberg]

Hi all,

I have a line graph showing two lines:

1. daily active users

2. 30 day rolling average of daily active users.

After modifiying my slicer date range (9/1/2018 - 9/30/2018), my data for daily active user are correctly filtered but the 30 day moving average is always showing 30 days more worth of data and one day less. 

[v-frfei-msft · Accepted solution]

Hi @RogerSteinberg,

What is your formula of your rolling average? I made one sample here for your reference. Everything worked well here.

Moving_Average = 
CALCULATE (
    AVERAGEX ( 'Table1', Table1[daily users] ),
    DATESINPERIOD ( Table1[date], LASTDATE ( Table1[date] ), -30, DAY )
)

For more details, please check the pbix as attached. If any other question, kindly share your pbix to me.

Regards,

Frank