Forum Discussion
sfmike99
5 years agoAdvocate II
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 ...
- Anonymous5 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.
mahoneypat
5 years agoMicrosoft Employee
Did you make that step using the filter pull down on that column? In any case, you can get to the M code either in the Formula Bar or the Advanced Editor. You can also pull down the same arrow on that column and modify that step that way too.
Regards,
Pat