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?
Bookmarks