Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Provide basic features for working in the Advanced Editor in dataflows - e.g. search, replace, intel

Please recognize that developers actually use the Advanced Editor in dataflows to modify the M-Code and provide at least BASIC support features for this.

 

- Find, Replace, Replace All

- Intellisense

 

And break up the script into multilple lines adding a step using the UI.  

 This format is very difficult to read:

  #"Merged queries" = Table.NestedJoin(#"Renamed columns", {"Company", "Customer No"}, #"Renamed columns", {"Company", "Customer No"}, "Renamed columns", JoinKind.LeftOuter)
 
 This is better-
   #"Merged queries" = Table.NestedJoin(#"Renamed columns",
      {"Company", "Customer No"}, #"Renamed columns",
      {"Company", "Customer No"}, "Renamed columns",
          JoinKind.LeftOuter)
 
People may have different opinions about where to add the line breaks in the code - but I guarantee you that if you asked 10 M-code designers, none of them would think that putting everthing in a single line is the best option.
Status: Needs Votes
Comments
miguel
Community Admin
Status changed to: Needs Votes