Forum Discussion
How to reference a parameter to a DAX function ?
It's a nice workaround, thanks!
aghonaim In power bi desktop go to query editor -> right click your parameter and ensure Enable Load is checked. Then Parameters are just like any other query in Power BI Desktop and so you can reference them in DAX expressions.
Assume I want to create a cacluated column that multiply column "A" in Table 1 by the paramater "Pam". I got this error:
Hi aghonaim,
In Power BI Desktop, we are not able to use Parameters in calculated columns. Regarding to this issue, you can vote it in the following existing idea.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12891723-parameters-calculated-fields-using-the-user-ente
Thanks,
Lydia ZhangOK I did vote, thanks!
Create a query new blank query and type = MYPARAMETER,
Than you can reference in columns/dax