Maxim on 06 Jul 2020 19:34:21
PowerQuery queries tend to get quite long. Some suggestions on auto-naming improvements that may help manage all the steps:
When creating Custom column rather than naming step "Added Custom" use the name of the column set by the user (example user adds column "Difference", the step should read "Added Difference"
The same goes for Invoke Custom Function. Add either column or function name into auto generated name
For MergeQueries use name of QueryMerged ("Merged Mapping" instead of "Merged Query")
Add a setting to remove all spaces from auto names in steps. This will be useful when writing code, as you don't have to use #"" (ex. you can use AddedCustom, not #"Added Custom").
When uding "Group by" function please add automatic name generation for aggregates. It can use the same algorithm as PivotTables use (ex. if we take Sum of column "Value" it shoud automatically populate the name as "SumValue"). Sometimes you need to make Group by with 15+ aggregates. It takes a lot of time to copy all the names.