Forum Discussion

CHill86's avatar
CHill86
Frequent Visitor
9 years ago

Moving Average - Visual Level Filters Applied

Hi, I got the moving average working as below:    MovingAverage2MonthAllRefs = CALCULATE (     AVERAGEX ( ALLSELECTED(Referrals), Referrals[Total] ),     DATESINPERIOD (         Referrals[Date],...
Need Help
CHill86's avatar
CHill86
Frequent Visitor
9 years ago

thanks for your reply, but would you mind explaining why a dates table is needed when my source table already includes a date?

SivaMani's avatar
SivaMani
Resident Rockstar
9 years ago

Hi CHill86,

Could you please try this,

 

MovingAverage2MonthAllRefs = CALCULATE (
    AVERAGEX ( ALLSELECTED(Referrals), Referrals[Total] ),
    DATEADD(
        LASTDATE ( Referrals[Date]),
        -2,
        MONTH
    )
)