Forum Discussion
Post PatronPassing a parameter to query: We cannot convert a value of type Table to type Function.
Hi crln-blue
When you use the table name data and then follow it with () PQ thinks you're calling a function. As data is a table, you get the error you are seeing.
What exactly are you trying to do?
It looks like you are trying to pass the string "End Cash" and the parameter into your data table for something. If you want to use the value for Param1 inside another query you can use its name.
Perhaps you can provide a screenshot of what your data table looks like and explain what you want to do with the string "End Cash" and the parameter.
regards
Phil
Super UserHi crln-blue
When you use the table name data and then follow it with () PQ thinks you're calling a function. As data is a table, you get the error you are seeing.
What exactly are you trying to do?
It looks like you are trying to pass the string "End Cash" and the parameter into your data table for something. If you want to use the value for Param1 inside another query you can use its name.
Perhaps you can provide a screenshot of what your data table looks like and explain what you want to do with the string "End Cash" and the parameter.
regards
Phil
Post PatronHello PhilipTreacy ! Thanks for the reply!
I want to use the parameter on my calculated measure. I saw somewhere that to be able to use it, I can pass it to a table. What If scenario won't work for me because I noticed that it only accepts up to 4 digits.
My data table is like this but has more columns. No computation on the data table since my computations are on a different table (summarized dax table):
So how do I use my parameter on a calculated measure? Thanks!