Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Last 7 day Average value

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?

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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] )