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