Forum Discussion
CHill86
9 years agoFrequent Visitor
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],...
Anonymous
9 years agoNot applicable
Instead of one table you should have at least two.
Create a Date table. Link it to your Referral table.
Try the following measure after the above steps.
MovingAverage2MonthAllRefs = CALCULATE (
AVERAGEX ( Referrals, Referrals[Total] ),
DATESINPERIOD (
Dates[Date],
LASTDATE ( Dates[Date]),
-2,
MONTH
)
)I changed the columns in the DatesPeriod function.