Forum Discussion

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

Icon for Solution Sage rank

Solution Sage

4 years ago

"For some reason, the calculation I have created for this shows the average revenue at the year level for the last 3 months of that year"

And this is correct. That's what it should be.