Max date price over a year

[pirotfab]

Hello,

I have a database with prices depending on a date.
I would like to obtain, for each item, the price for the last date of the year.
Can you help me ?
Attached is an Excel example

Fabien

thanks

[MayilVahanan]

HI

Try like below

LY: FirstSortedValue({<caldate={">=$(=Date(YearStart(Max(caldate),-1),'DD-MM-YYYY'))<=$(=Date(YearEnd(Max(caldate),-1),'DD-MM-YYYY'))"}>}pua, -caldate)

TY: FirstSortedValue(pua, -caldate)
or
FirstSortedValue({<caldate={">=$(=Date(YearStart(Max(caldate)),'DD-MM-YYYY'))<=$(=Date(YearEnd(Max(caldate)),'DD-MM-YYYY'))"}>}pua, -caldate)