How to calculate average of a measure for previous 6 months

[Anonymous]

In the below example, I am getting only Forecast and Actuals data from input , Error% is calculated in a measure.

Problem I am facing is I could not find average of the Measure(Error%) over last 6 months

I could calculate last 6 months average only if it’s a column, but here I need to calculate average of measure for last 6 months.

Month	Forecast	Actuals	Error	Error%	Error % Previous 6 Months
Jan-18	1300	908	-392	-43.1718	-5.877063516
Dec-17	509	809	300	37.08282	-1.401762488
Nov-17	602	890	288	32.35955	-3.612194751
Oct-17	708	560	-148	-26.4286	-4.205453177
Sep-17	809	709	-100	-14.1044	1.732642061
Aug-17	1089	900	-189	-21	4.179862015
Jul-17	2908	2500	-408	-16.32	4.951248445
Jun-17	678	890	212	23.82022	8.443975718
May-17	356	500	144	28.8	5.368725918
Apr-17	908	1000	92	9.2	-0.489092603
Mar-17	1889	1900	11	0.578947	-3.718790137
Feb-17	789	678	-111	-16.3717	-5.86765889
Jan-17	2098	2200	102	4.636364	4.636363636

[v-chuncz-msft]

@Anonymous,

You may use a similar way as shown here.

[Anonymous]

@v-chuncz-msft

The problem here is Error% is a measure calculated in Report.

I need to calculate past 6 months average on a measure (Error%)

Your solution will work only if I calculate past 6 months average on a column.

[v-chuncz-msft · Accepted solution]

@Anonymous,

It applies to measure as well.

https://community.powerbi.com/t5/Desktop/Sum-of-values-in-a-measure-with-divide-measure/m-p/296768#M130947