How to calculate average for last 8 records in pivot

[Nicky]

Hi, I have a pivot table. Can I get the average of the last 13 records for each column?

Average by per1 column

[SteveCampbell · Accepted solution]

Try this:

Average Last 13 = 
CALCULATE(AVERAGE('Table'[Value]),TOPN(13,VALUES('Table'[min_date]),'Table'[min_date],DESC))

Change the red to match your tables and columns!

You can add a matrix with just the columns and the new measure.