Forum Discussion

JSiebrecht's avatar
JSiebrecht
Icon for Resolver I rankResolver I
4 years ago

Rolling average for X entries

Rolling average NOT on dates Dear community, I am trying to calculate a rolling/moving average across the last e.g. 100 entries. But all tutorials I found so far were always on a number of day...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi JSiebrecht ,

 

You could add index column in Power Query Editor.

Then create a measure like below.

Measure = CALCULATE(AVERAGE('Table'[Duration]),FILTER(ALLSELECTED('Table'),'Table'[Index]<SELECTEDVALUE('Table'[Index])+10&&'Table'[Index]>=SELECTEDVALUE('Table'[Index])))
 
Best Regards,
Jay
  • JSiebrecht's avatar
    JSiebrecht
    Icon for Resolver I rankResolver I
    4 years ago

    Dear Anonymous 

    many thanks for your input.

    While this as a formula seems plausible, in my case it will just not evaluate.
    The amount of records simply seems to be too large to calculate this in a meaure.
    Trying to put it into a custom column gives me calculated SMA values that make no sense at all.

    Oh, well. I guess my business user will just have to make due without a moving average and look at the timeseries as is.

    Thanks anyway y'all!