Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Rolling 3 months Average

Hi everyone.   I have encounter an issue on my report and need your help. I need a calculation of Trend and it's definition is: Average of the last 3 months of the month selected.   If my slice...
average
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try a measure like this with help from date table

 

Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-1),-3,MONTH))