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. 

newguy's avatar
newguy
New Member
4 years ago

I gave this a shot this morning and still had the same issue. I created a new, pared down version with just the fact and date tables (posted in reply to another comment), no dimensions. Seem to be getting the same type of issue even with just two tables and one join. 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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.