Forum Discussion

arnabmit's avatar
arnabmit
Icon for Helper I rankHelper I
4 years ago
Solved

Error in Rolling 12 month average

Hi,   I was trying to replicate Alberto Ferrari's method of Rolling 12 month average (Average of -13 to -1 month), but it is not matching with the manual calculation. Any idea why it is so?   My ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    arnabmit , Check the suggestion from SpartaBI. Try like

     

    12 Month Avg = CALCULATE(AverageX(Values('Date'[MONTH Year]),calculate(Sum('Table'[Value)))
    ,DATESINPERIOD('Date'[Date ],Eomonth(MAX('Date'[Date ])-1) ,-12,MONTH))

     

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

arnabmit I'm not sure why you have another disconnected calendar table. 
You can PM me and we can take a look together at your model in zoom if you want