I am trying to create chart that can show the last appeared number on certain date.
I have 2 columns, one contains dates and one contains values, I need expression that shows the value on the last existing date(maximum date).
something similar to Excel Function =VLOOKUP(MAX(B3:B26),B2:D26,3,FALSE)
can anyone help me with that?
Hi @Sally3 !
The way to solve your problem is using the FirstSortedValue() function.
View solution in original post