[ Average of last 6 months ]

[bolabuga]

Hello everyone, needing help with metric and/or calculated column to calculate the average of the last 6 months for each client each month.

Theres a sample pbix file for reference.

https://drive.google.com/open?id=0B8Aq8DhGApJqYkpxVzdITzlMRkE

[Phil_Seamark · Accepted solution]

Try adding this to your model and let me know how you get on.

Average of last 6 months = AVERAGEX(
					DATESINPERIOD(
						'SAMPLE'[REFER],
						LASTDATE('SAMPLE'[REFER]),
						-6,
						MONTH)
						,
					[REVENUE TOT]
					)

[bolabuga]

@Phil_Seamark

Thks phil, I tested and its working.