Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)