Forum Discussion
Dynamic M Query Binding Advanced Properties Missing
When I select the date table EndDate = CALENDAR(DATE(1970,1,1),TODAY()) to bind to the DirectQuery Parameters I set up similar to(https://www.youtube.com/watch?time_continue=586&v=pXU_SpiBWUA&feature...
StartDT in the screenshot is the field, not the table. Selecting the field the bind to parameter is missing. It seems like there is a limitation where if your date field is a before slicer with the calendar function, you can no longer bind to parameter. If you bind to the parameter, the date field slicer can only be list or dropdown, but you lose the calendar function. Is this intended behavior?
There seems to be a bug. Even with the list/dropdown slicer the Advanced properties section has disappeared.