Forum Discussion
Date Input manually by user to help with formula
Hi Selvarajen
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/zhWtU0DynCkThen 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 !
Super UserSelvarajen , refer if this blog on a similar topic can help. seem like you are looking for current employee kind of measure
Dear Amit.
Thanks for your message and the blog.
It is very insightful but unfortunately, our date range might be from 1980 to 2030 (50 years) which will be very hard to filter from.
That is one of the reasons i was looking for a more dynamic user input text filter that could be used.
Is there any other way the date filter could have a search option, that would also minimize the effort as a work around
speedrampsHi Selvarajen
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/zhWtU0DynCkThen 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 !speedramps Thank you so much. Of course, if there is an option to give you an heart, i would definitely do that.
Your solution helped me fix the problem and also use it in multiple other requirements.
I appreciate you taking the time to help me out here.
Best Regards,Selvarajen
- speedramps
Awe ... thank you Selvarajen, that is the nicest thing anyone has said to me on forum!
Glad my solution helped.