Forum Discussion
Parameter/Bind variables based on Date Calendar Input
The requirement is to restrict the direct query table rows based on Start and End Date calendar inputs as it is a huge transaction table. Created 2 Calendar tables using DAX : Start Date - Calendar...
Hi Anonymous
I'm afraid this is not supported as it would hit another limitation:
- A single parameter can't be bound to multiple fields nor vice-versa.
In a date slicer, it only has one date field, which cannot be bound to two paramters.
Best regards,
Jing
Is there any other workaround? I also tried to create a calculated column based on date selection i.e. FIRSTDATE() and LASTDATE() and linked it with variable but had no luck, would you know if I can create a date_table2 that will hold MAX and MIN dates of date_Table1 , when a date range is selected in date_Table1, table2 Max and Min columns will be filtered and hold the start and end range values?