Pass Date Parameter to Advanced Editor

[pinkydingy]

Hi All,

May i know how to pass date parameter to Advanced Editor without converting to Text as i have to display it for my chart. 

When i Run this query, 

It shows me this error: 

May I know how to solve this problem?

Your help is much appreciated! 

[v-piga-msft]

Hi @pinkydingy,

It seems that you have problems when your create parameters in Query Editor.

You could have a reference of this similar thread which has been solved.

In addition, if you're not clear about M query, we could create query parameters by clicking Manage Parameters under Query Editor.

If you still need help, please share a dummy pbix file which can reproduce your scenario and your desired output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best  Regards,

Cherry

[pinkydingy]

Hi, I want to create a parameter at the advance editor based on the time range that the user choose, however it is based on different table. I search some sources they used &(Parameter)& , may i know how am i able to use this function? 

'

** start_time and end_time** are the ones i want to use it as parameter. 

Your help is much appreciated!