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.
... View more