Forum Discussion

newguy's avatar
newguy
New Member
4 years ago
Solved

Issue With Rolling 3 Month Average

I know there are alot of rolling average posts out there, but I haven't been able to find a solution to my issue. I am trying to get a 3 month rolling average of revenue, example below:   For...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi newguy 
    Would you please double check and confirm if the date table is marked as date table. In all cases would you please add REMOVEFILTERS ( D_Date ) inside CALCULATE and let me know if you get any different results. 

daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago

If it isn't, this means your model is different to the model Alberto uses. Can you please post a  readable picture of your model?

newguy's avatar
newguy
New Member
4 years ago

Looks like it was just me not realizing the date table had to be specifically marked in SSIS for these calculations to work. Thank you again for all the help!