Moving Average on last 3 records

[odobo]

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?

[ValtteriN · Accepted solution]

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/

[odobo]

thanks that works!