Date Input manually by user to help with formula

Hi Selvarajen

Click here to try this demo 

Note that you type the date in the slicer or you can select it from the calendar menu.

It then indicates which rows are valid. You can then adapt this to just show the rows you want.

How to do it:-

Use the List.Date function to create a list of dates from 1990 to today.

Add a date slicer using this trick
https://youtu.be/zhWtU0DynCk 

Then add this measure

Indicator =

--- get slicer date

VAR pickdate = MIN(Picklist[Date])

--- create a subset of the table where the pickdate is between the valid from/to range  

VAR data_within_range =

FILTER(Facts, pickdate  >= Facts[Valid From] && pickdate <= Facts[Valid To])

Return

--- Is the subset empty ?

INT(NOT(ISEMPTY(data_within_range)))

+ 0

Remember we are BI community voluntrees so please click the thumbs-up for me taking the effort to help you and then accept the solution if it works.  Thank you !