Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please find attach sample data with in sheet 2 required output
Try:
Max Purchase Date Price: FirstSortedValue({<Year={'$(=Max(Year))'}>} [Unit Price], -Date)
Min Price: Min({<Year={'$(=Max(Year))'}>} [Unit Price])