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 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, example below: My Net Revenue measure uses USERELATIONSHIP to activate the service date link since I have multiple dates on my fact table:Total Net Revenue by DOS:=CALCULATE( [Total Revenue],USERELATIONSHIP(D_DATE[W_DT_ID],Fact_Charge[W_SERVICE_DT_ID])) My attempt at the rolling 3 month average shown here:Net Revenue R3M:=VAR NumOfMonths = 3VAR LastSelectedDate = MAX(D_DATE[Calendar_Date])VAR Period =DATESINPERIOD( D_DATE[Calendar_Date], LastSelectedDate, -NumOfMonths, MONTH)VAR Result =CALCULATE(AVERAGEX(VALUES(D_DATE[Month Year]),[Total Net Revenue by DOS]),Period)ReturnResult Any help on this would be fantastic as I have several metrics I need to set up that utilize a 3 month rolling average. Thank you!

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.

Issue With Rolling 3 Month Average | Microsoft Fabric Community

Forum Discussion

Related content

Rolling Average Issues

Rolling 12M Average measure

3 Day Rolling Average - DAX

Rolling accumulation

Rolling accumulation