Forum Discussion
Grouped moving average for defined
Hi All, I have a table like this Countries Cities Years Temperature Country1 City1 Year1 Temperature(value) Country1 City1 Year2 Temperature(value) ...
Hi Anonymous
Please tryTemp Moving Average = CALCULATE ( AVERAGE ( TableName[Temperature] ), ALLEXCEPT ( TableName, TableName[Countries], TableName[Cities] ), TableName[Years] <= MAX ( TableName[Years] ) )
tamerj1
Community Champion
Community ChampionHi Anonymous
Please try
Temp Moving Average =
CALCULATE (
AVERAGE ( TableName[Temperature] ),
ALLEXCEPT ( TableName, TableName[Countries], TableName[Cities] ),
TableName[Years] <= MAX ( TableName[Years] )
)