Show Price for Min Date

[v_jaideep]

Hello, 

I'm able to get the launch Price through below expression. But the value changes when date is selected.

I don't want the price value to change irrespective of the date selection. It should always show the price on minimum date.Suppose minimum date 01/01/2000 and price is '100' and date selected from filters is 01/01/2021.Price should still show '100'

FirstSortedValue(distinct local_price,effective_start_date))

[mato32188]

Hi @v_jaideep ,

have you tried to use set analysis in your expression, like 

FirstSortedValue({<YourDateField>} distinct local_price,effective_start_date))

BR

m