Closest actual date

[Elmarius123]

I have a Table 1. 

This a table with consisting of  dates when limits changed and actual limits.

I also have a slicer with dates.

I want - when i select a date in the slicer, it would show me the actual limit from table 1. if the dates do not match, it needs to show me the last actual dates limit before the date in the slicer.. 

 

 

[amitchandak]

@Elmarius123 , You an get a date like

measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = mainx(allselected(Date),Date[Date])
return
calculate(Max(Table[Date]), filter(Table, Table[Date] >= _min && Table[Date] >= _max))

or you use this max date to calculate other thing

[Elmarius123]

Spoiler

Hi, amitchandak. Actually, i am making a Gauge visual. In this visual, i have a Target value.. this target value should change regarding of month, say in october Target value was 45%, only in December it is changed to 65%. When i select November, there should be shown acting Limit, which is 45%(October)