Forum Discussion

tgjones43's avatar
tgjones43
Icon for Helper IV rankHelper IV
3 years ago
Solved

3 year rolling average required

I've seen a few rolling average posts and YouTube videos but can't seem to find one that works for my dataset, which contains the concentration of elements in rivers. I have frequent measurements of...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    tgjones43 , with help from date table

     

    3 Year Avg = CALCULATE(AverageX(Values('Date'[Year]),calculate(Average('Table'[Concentration] )))
    ,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,Year))

     

steph1234's avatar
steph1234
Regular Visitor
3 years ago

I was reading through this thread and was wondering what formula was used to calculate the annual average, if you could let me know that would be great.