Max Set analysis by product

[BearNBeer]

Hello,

I am trying to use set analysis in order to get the most recent price of each of my products.
So far my formula is : 

Avg( {$<date = {"$(=Max(date))"}>} Price)

This works well but it only displayed the most recent price of 1 out of 2 products : 

How can I change my formula to also display the 91.57 price of my Product 1 in addition of the 8.891 price of my product 2 ?

Thank you for your support.

[tresesco · Accepted solution]

Take product_code as your only dimension in the chart, and then expression like:

Firstsortedvalue(Price, -date)

[BearNBeer]

Just needed to add DISTINCT :  Firstsortedvalue(DISTINCT Price, -date) and it worked
Thanks !