https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-3-month-average/m-p/240626#M156500 <P>Good day,</P><P>&nbsp;</P><P>I am looking for a measure where i can average the last 3 months revenue, excluding the most current month. I want to compare July revenue to an average of April, May &amp; June revenue. I do have a separate date table.</P><P>&nbsp;</P><P>the measure i tried was:</P><P>Revenue 3 Mo Rolling Avg = CALCULATE([TotalRevenue],DATESINPERIOD(DateDim[Date],LASTDATE(DateDim[Date]),-3,MONTH))/3</P><P>&nbsp;</P><P>This measure gives me the average for May, June and July. Any ideas?</P><P>&nbsp;</P><P>Thank you!</P> Mon, 28 Aug 2017 18:29:37 GMT Mark_Ball 2017-08-28T18:29:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-3-month-average/m-p/240626#M156500 <P>Good day,</P><P>&nbsp;</P><P>I am looking for a measure where i can average the last 3 months revenue, excluding the most current month. I want to compare July revenue to an average of April, May &amp; June revenue. I do have a separate date table.</P><P>&nbsp;</P><P>the measure i tried was:</P><P>Revenue 3 Mo Rolling Avg = CALCULATE([TotalRevenue],DATESINPERIOD(DateDim[Date],LASTDATE(DateDim[Date]),-3,MONTH))/3</P><P>&nbsp;</P><P>This measure gives me the average for May, June and July. Any ideas?</P><P>&nbsp;</P><P>Thank you!</P> Mon, 28 Aug 2017 18:29:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-3-month-average/m-p/240626#M156500 Mark_Ball 2017-08-28T18:29:37Z