Forum Discussion

odobo's avatar
odobo
New Member
4 years ago
Solved

Moving Average on last 3 records

hi, I am trying to calculate a moving average of the last 3 records, I dont have a time stamp on these records so I cant filter the data with Datesinperiod or someting similar, but the table have a index column to count 

 

I cant figure out how to calculate the moving sum or moving average by filtering the last 3 recording using the index column, I have tried using

= Calculate (Sum(Table1[Value]) , Filter(Table1, Table1[Index] <= SUM(Table1[Index]) && Table1[Index] >= SUM(Table1[Index])-2)

but the table return 0

 

any advise on how to filter the past 3 records with index?

Moving average
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi,

    Try something like this:

    var  _index = max(Table1[Index]) return
    Calculate(Sum(Table1[Value]) ,all(Table1), Table1[Index] <=_index, Table1[Index] >= _index-2)


    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

2 Replies

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi,

    Try something like this:

    var  _index = max(Table1[Index]) return
    Calculate(Sum(Table1[Value]) ,all(Table1), Table1[Index] <=_index, Table1[Index] >= _index-2)


    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/