Edit Multiple instances of Field Name in Advanced Query Editor

Power Query
1

I just watched the Report Development Best Practices videos and one of the sections talks about where you can use “Shift” + “CTRL” + “L” and then you are able to edit all occurrences of a field name in a DAX measure. My question is, can you do the same in the Power Query advanced editor? I tried those key strokes but they don’t work. However when you select a field name in the advanced editor, all instances of the field are highlighted. So I would like to change the name all at once if possible.

Thanks!

2

Hi @patrickcox. AFAIK this is only a DAX Editor feature … I’m not aware of a corresponding PQ feature, but will be interested in others’ comments.
Greg

3

Hi @patrickcox,

@Greg is correct, currently that functionality or ‘find and replace’ equivalent is not available in the PQ Advanced Editor.

All the best

4

@patrickcox You can copy the code and use any basic text editor to perform that operation.

1 Like
5

@patrickcox ,

Visual Studio Code actually has a free third-party IntelliSense plug-in for M code if you have the need for heavy duty M code editing.

  • Brian
6

Hello @patrickcox, just following up if the responses above help you solve your inquiry?

If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

7

Sorry, I forgot!