Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Column Renaming based on Drop Down List

I have a table and a drop down list which uses a power query connection. My current set up allows the user to select an option from the drop down list and the some of the table columns will change t...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Anonymous ,

You can try to convert them to list to rename the columns' name.

Please refer these articles which introduce it in details:

  1. Dynamic Column Names in Power Query 
  2. Rename column names in a dynamic way 

 

In addition, you can try to create a custom function to rename them:

Using M to dynamically change column names in PowerQuery 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks Yingjie Li,

I've tried it via number 1, and got a list of lists with an additional column for the FilterAssetClass choice in this example. But I'm not able to figure out how to make it conditional on the user choice.

If I wanted to convert from the 5 column names to 5 other names only it would work, but I want to convert 5 columns names to 5 other names based on what the user has sellected and it's that condition that I'm stuck on if you have any advice? 

Essentially I want it to take in the dropdown list selection, and check that selection through a table and then when it matches replace old columns to new columns (specific to that dropdown list). Which I think neither of the links helps with.