Forum Discussion

doume06's avatar
doume06
Helper I
2 years ago
Solved

Help on rolling average

Dear community, I reproduced an issue I face on rolling average calculation: I want to calculate a rolling average on 3 months in a table of 12 months and twelve values: I have a calendar table. ...
General Comment
  • doume06's avatar
    doume06
    2 years ago

    Thanks Daniel, WINDOW function works fine in the table. Now my real dataset is not a table but a measure so it's a different approach. I will try to find the solution with what you gave me.

    Thanks again for your help.

     

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

doume06 

while still investigating the issue, 

 

you can use this measure : 

new measure = 
var s = 
SUMX(
    WINDOW(
        -2,REL,
        0,REL,
        SUMMARIZE(allselected(RAW),RAW[month],RAW[value]),
        ORDERBY(RAW[month], ASC)
    ),
    RAW[value]
)

return s / 3
doume06's avatar
doume06
Helper I
2 years ago

Thanks Daniel, WINDOW function works fine in the table. Now my real dataset is not a table but a measure so it's a different approach. I will try to find the solution with what you gave me.

Thanks again for your help.