Edit a calculated column in Query Editor

[Anonymous]

Good morning,

I created a calculated column in query editor ages ago, and i've realised that for some reason it's stopped working properly so I want to check what it's doing. 

I want to view/edit the formula, but I don't know how to do this.

I'm in Query Editor, i've got the column highlighted, how do I edit? 

Thanks!

Jemma

[Stachu · Accepted solution]

hi Jemma

in View ribbon you need the Query Settings pane enabled - it shows list of steps in currently selected query

you need to identify the step which added the column and click on the gear icon next to it - it will bring back the add column window, where you can edit

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Just double left cilck the step in the APPLIED STEPS field, then you can edit the formula.

Regards,

Frank

[Stachu · Accepted solution]

hi Jemma

in View ribbon you need the Query Settings pane enabled - it shows list of steps in currently selected query

you need to identify the step which added the column and click on the gear icon next to it - it will bring back the add column window, where you can edit