Forum Discussion
Anonymous
4 years agoNot applicable
Bind to Parameter Not Showing
Hi, I have user sql query, Start date and end date.i try all below solution. 1.create a parameter then create a calaender table but in property -> advance option not show bind parameter functionali...
Anonymous
4 years agoNot applicable
Hello,
This worked for me, but my case is slightly different, since the date I needed as a parameter is easily obtained using M functions and I'm using an OLAP query instead of a SQL one:
i) Instead of creating a brand new parameter through the Manager Parameters > New Parameter > etc, I created a New Query called "p_date", where I wrote the functions to obtain my date;
ii) Then, I selected the OLAP query, opened the Advanced Editor and replaced the (let's call it) fixed value by the p_date and ta-daaaaaaaaaa, it's done.
Would it work for you?