passing date parameter to sql function using bind to parameter

[0Anna0]

I have a SQL function that accepts 2 parameters: date and number. I've created all the necessary parameters and bound them to the function (that I've imported) inside the advanced editor also, I have two tables with the dates and numbers that I need to pass to the function, and I bind the relevant columns to the parameters. while I'm passing the number parameter everything looks okay and I'm getting the table (date has default value if not inserted to the function) but once I'm choosing the date everything seems to collapse. it seems to me that there is a problem with the conversion of the date while passing to the SQL function. is there someone who came across the same problem? 

[Anonymous]

Hi @0Anna0 ,

Here is an offical blog and I hope it could help you solve your problems.

For reference:

Dynamic M query parameters in Power BI Desktop

And here is a video about dynamic M query parameters in Power BI Desktop.

How to update M query parameters based on filters and slicers

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.