Can you explain how this is working please?
I was trying to work out a moving 7 day average but the normal pattern seems to ignore days when the key measure = 0
eg. sales of 50 on 5 days should give a 7 day average of 250/7 ie 35.7 but it gives 50
If I change the formula to the following this seems to work
Avg Calls 1W MA = AVERAGEX( DATESINPERIOD( Dates[Date], LASTDATE( Dates[Date] ),-7,DAY), [# of Calls] **+ 0** )
Why is this?