Forum Discussion

busybee's avatar
busybee
Helper I
6 years ago
Solved

Parameters

I have a Power BI file and have imported an Excel file using Edit Queries. I created 2 new parameters. When I try to create a function to dynamically change the parameter value on the Excel sheet I i...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    You are missing a step between 4 and 5.

     

    Creating parameters doesn't put them in a query. You have to reference the parameters in the query. So to test this, assume your parameters are numbers, and one is called parTestValue. Create a custom column that is =[SomeNumericColumn] * parTestValue

     

    Now you can right-click on the query and create a function. It will only be using the parameter(s) you are explicitly using in the query.

edhans's avatar
edhans
Community Champion
6 years ago

You are missing a step between 4 and 5.

 

Creating parameters doesn't put them in a query. You have to reference the parameters in the query. So to test this, assume your parameters are numbers, and one is called parTestValue. Create a custom column that is =[SomeNumericColumn] * parTestValue

 

Now you can right-click on the query and create a function. It will only be using the parameter(s) you are explicitly using in the query.

busybee's avatar
busybee
Helper I
6 years ago

Thanks. That solution worked.