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. 

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. 

newguy's avatar
newguy
New Member
4 years ago

It looks like that was the issue. I didn't realize the date table had to be specifically marked inside my SSIS Tabular model for those types of calculations to work. I apologize for all the time spent on something so simple - part of being new to DAX/Power BI I guess -  but I appreciate all of the help! Thank you so much!

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    newguy 

    No problem. Actually it was late at night yesterday when I was trying to find a solution and directly after that went to sleep. The first thing that came to my mind before I close my eyes was the date table.  Actually time intelligence functions include many hidden functions that do not work if the table was not marked as date table. DATESINPERIOD includes REMOVEFILTERS which was apparently not working.