Rate of Change of Moving Average

[kadapavel]

Hi,

I have a measure which calculates moving average and now I'd like to calculate growth in % of the moving average. 

Is there a way to calculate such a thing?

Already tried with minx and maxx, it calculates min and max of each day and my moving average is for 30 days 

BR

Pavel

[Stachu]

can you share sample anonymised data and the syntax for the measure you're using?

[kadapavel]

Hi Stachu,

Table is like this

Measure syntax is

PMR-MA = if(ISBLANK(max('KPI Indices'[Rolling INdex])),BLANK(),

	VAR __LAST_DATE = LASTDATE('KPI Indices'[ResultDate])
	RETURN
		AVERAGEX(
			DATESBETWEEN(
				'KPI Indices'[ResultDate],
				DATEADD(__LAST_DATE, -30, DAY),
				__LAST_DATE
			),
			CALCULATE(SUM('KPI Indices'[ResultValue]))
		))

Result is

[Stachu]

do you mwan something like this?

Measure = 
VAR PrevDay = MAX('KPI Indices'[ResultDate])-1
RETURN
[PMR-MA]-CALCULATE([PMR-MA],'KPI Indices'[ResultDate]=PrevDay)

if you need %change then yo ucan use DIVIDE