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))

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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))

 

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

thanks amitchandak in my report the 3 year average is just matching the annual average. Would you mind attaching your pbix so I can try to figure out where I am going wrong?