Last 7 day Average value

[Anonymous]

hello!

I have this measure to get the last 7 days costs from my all costs measure. 

costs in last 7 days =

VAR last_Date = LASTDATE('Usage details'[Date] )

RETURN

CALCULATE( [3. (Vm + Backup) + NotVms + Mgm Fee],

FILTER(ALL('Usage details'[Date]),

'Usage details'[Date] > last_Date - 7 &&

'Usage details'[Date] < last_Date ) )

Now I need to have the average of this 7 days in order to create a trend graph between the 7 days AVG and last day costs.

Could you guys help me? i tried to use the AVERAGE, but it does not accept a measure (or I don't know exactly how to use it)

Can we add an average in the above code?

[Greg_Deckler]

@Anonymous Try:

costs in last 7 days =
VAR last_Date = LASTDATE('Usage details'[Date] )

RETURN
AVERAGEX( FILTER(ALL('Usage details'[Date]),
'Usage details'[Date] > last_Date - 7 &&
'Usage details'[Date] < last_Date ),[3. (Vm + Backup) + NotVms + Mgm Fee] )