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]))
			)
EvanWright's avatar
EvanWright
Regular Visitor
9 years ago

That worked perfectly thank you so much!

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi EvanWright,

     

    Great to hear the problem got resolved! Could you accept the corresponding reply as solution to help others who may have similar issue easily find the answer and close this thread?:smileyhappy:

     

    Regards