Dynamic M Query

[slalithprasad]

Hello I am trying something like this and it is not working, please help -

Works when Creditor = 'japan' and also works when i use amount > " &amount])

amount Paramter type is Text and List of Values with 40,50,60 and it works

credit Parameter type is Text and List of Values with France, Japan and UK

but doesn't work like this -

What am i doing wrong? please help me understand, thank you.

[v-eqin-msft]

Hi @slalithprasad ,

Please take a look at this case for reference.

https://community.powerbi.com/t5/Desktop/DataSource-Error-Invalid-column-name/td-p/627036

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[PhilipTreacy]

Hi @slalithprasad 

I can't see anything wrong with your query if the parameter credit really does contain the text value France.  Odd that the error is about an invalid column name.

Can you create another query to check the value of the credit parameter, like this:

let
    Source = "The value of the credit parameter is " & credit
in
    Source

What result do you get when you hard code the text France into the query (as you did with Japan) ?

Can you please share the entire query or PBIX file so I can see all the code.  Including the query for creating the parameters.

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.