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.

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

The issue is when clicking on the gear the condition editor window starts to open (youc an see the frame of the popup box) but it is transparent and now the application is stuck.  Clicking anywhere causes a "ding" sound.  I can work outside of excel/powerquery but not inside.  No options to cancel/close.  Only can kill the process.  Any ideas?