Forum Discussion

sfmike99's avatar
sfmike99
Advocate II
5 years ago
Solved

How to get back to Query Editor after adding custom column?

I add a custom column in Power Query using Query Editor. This is a conditional column. However when I go back to edit it, it opens the conditional column guide (below) instead of the editor. How can ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    sfmike99 
    Because you have used if function in the formula, which is recognized as a condition column by default. In this case, you can edit the formula in the formula far or in the advanced editor.

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

sfmike99's avatar
sfmike99
Advocate II
5 years ago

No I created it using "Add Column-Custom Column" which puts me into the Query Editor. When I click on it next time to edit, it takes me into the "Add Conditional Column" tool which I don't want. Here's how to reproduce:

Create a custom column like "if [Index] = 1 then [Index] else [Value]"
Save it and then clidk on the gear icon.

 

It takes me into the Conditional Column helper and I can't get back to the Query Editor.