power query help needed with Parameter Setting

[prinsr]

Hello all,


I have a problem with power query. I hope someone can help me with the following problem:

In excel I created a "ParameterTable". The table is as follows:

Parameter Value
JobDes_1 xxx
JobDes_2 yyy

I would like to integrate the parameters in query. This allows users to change the parameters in Excel easily without having to update the query manually.*

Previous query:

JobDescription ='xxx' or*JobDescription ='yyy'

I would like to change this part to:*

JobDescription = fParameter("ParameterTable", "JobDes_1")



However, I get the following error:*Expression.SyntaxError: Token Comma expected. The error underlines "ParameterTable"

fParameter is a blank query by the way.*

Can you help me with this?

[alansidman]

Because it says you are missing a comma, I think this video will explain and help you to make sure that you have settings correct. Without seeing your Mcode, it is difficult to determine your needs.

https://www.youtube.com/watch?v=h42vv5cq0PY