Average Item Cost on Last 5 Invoices

[PeterL1]

Hi, 

I'm struggling to find an answer to an issue that i have.

I am trying to get out the last 5 invoices by supplier down to an itemised level (by date), to calculate an average cost on the item for those last 5 invoices.

The Invoice dates ranks back to 2009, but i cannot just take invoices from say this year as i might not have bought something for 18 months etc.

This is the Data i have:

 

This is the data i would like, by supplier and by item within that supplier.

Any help on this would be appreciated.

Thanks

Peter

[Phil_Seamark]

Hi @PeterL1

Do you have some sample data that we can cut/paste into a model?  And what are your table names?

[PeterL1]

Hi @Phil_Seamark

Please see below link for data example.

https://www.dropbox.com/l/scl/AACHeYibKkWAnRxJTe5cW6aiJPgsZLUr6Dc

Thanks

Peter