Forum Discussion
Functions and Parameters in Add Custom Column
Hi All, Um not aware of DAX and want to create custom columns in query editor. non of the functions are working in the expression except control flow statements (IF) or any arithmetic operators(...
Anonymous
In Power BI Desktop April or later version, you can create Query Parameter in Query Editor. You can specify "Any Value" or "List of value" for input or selection.
Then you can use this parameter in your custom column as condition.
To edit the parameter when filtering data, you can just go to "Edit Queries" ->"Edit Parameter".
For more information, please see: https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/