Forum Discussion

EvanWright's avatar
EvanWright
Regular Visitor
9 years ago
Solved

Moving Average Measure

Hello,   I need help with a Moving Average. I have read through many of the other messages, but I can't seem to get this one to work. I need to know the moving average of the Count by Steam,Target ...
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Try this measure.  I've assumed your table is called 'Stream' and this calculates for 3 weeks (the -21 days)

     

    Moving Average = 
		AVERAGEX(
			DATESINPERIOD(
				'Stream'[WeekStart],
				LASTDATE('Stream'[WeekStart]) ,
				 -21 , 
				 DAY),
			CALCULATE(sum('Stream'[Count]))
			)
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi EvanWright,

 

Have you tried the formula provided by Phil_Seamark? It should work in your scenario. If you still have any issue, feel free to post it out here.:smileyhappy:

 

Regards