Forum Discussion
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 ...
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.
Here's what I have as a workaround for your problem.
Original formula as below and it will not take me to the custom column editor window if I have any changes.
For the time being, I change the else output.
I just added "1 & ", which I will remove once I go to the editor window.
And now it takes me to the Custom Column editor as I wanted.
Please let me know if you have any other solution.