Average of months

[harib]

I want show 3 months average in my table. 

SAP BO report they have used below formulas to get the out put

Main formula : ERI 3MRA Rate % =If [Report Month]<[3MAverageStart] Then 0 Else [ERI Average Rate 3 Months]*100

• ERI Average Rate 3 Months= ((RunningSum([ERI Ratio(%)]) - RunningSum(Previous([ERI Ratio(%)]; 3))) / 3)+0
• 3MAverageStart =FormatDate(RelativeDate(ToDate(Min([Report Month]) In Report;"yyyy-MM");2;MonthPeriod);"yyyy-MM")

This formula for your reference to get ERI Ratio :  ERI Ration(%) = DIVIDE([ERI_Return_Qtys],[ERI_Ship_Qtys]))

Sample Data

https://drive.google.com/file/d/1brZTsnfqx0mTryREYkTrb5PreaC5mO8a/view?usp=sharing

If possible can u please provide sample PBIX file. 

Thanks in Advance

[v-chuncz-msft · Accepted solution]

@harib ,

You may view the code generated by Quick measure Rolling average and take a look at this post.