Dax- For each group average the 3 highest values in the 5 most recent entries.

[askelton]

I have data as structured below in A-C, with many more groups and dates.  

In Dax I would like to average the 3 highest values in the 5 most recent entries for each group, to obtain results like shown in E and F.  (e.g For B, I would be looking to average lines 11, 12 and 14)

The dates will not always be the same for each group, and there may be gaps in dates for certain groups.  

[askelton · Accepted solution]

Solved: See https://community.powerbi.com/t5/Desktop/Avg-from-a-Variable-Table/m-p/269454#M121411

[askelton]

bump