Filter table with conditions based on selected value of slicer
I have one sql table named as INFO with columns (project, startdate,enddate)
I created calender table using DAX : Calender = ADDCOLUMNS(CALENDAR (DATE (1990, 1, 1), DATE (YEAR(TODAY()), 12, 31)),"DateInt",FORMAT([Date],"mm/dd/yyyy")) I followed "https://www.youtube.com/watch?v=zhWtU0DynCk" to get single date selected by user from slicer.
I want to filter my INFO table as startdate <= selecteddate from slicer <= enddate.
When you create a table, you cannot access the slicer selection values as the model gets finalized prior to your report layer where the slicer exists. If you are creating a virtual table within a measure, you can access the slicer value using SELECTEDVALUE function.
If you want to achieve dynamic filtering of your data when you pull it from the server then Dynamic M Query Parameter which a new feature would help you:
I tried to follow the above documentation and as there is limitation "A single parameter cannot be bound to multiple fields nor vice-versa" . In my case I want to bind same parameter to two columns (startdate and enddate).