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.

     

doume06's avatar
doume06
Helper I
2 years ago

Hi Daniel,

Thanks for your answer.

Here we go: .pbix and RAW file

https://we.tl/t-qzpgDgCZ6E

Tell me if you see something wrong.

Thanks a lot for your help.

Dominique

 

  • 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.