Matt Allington on 04 Mar 2022 20:35:30
The Applied Steps pane on the right (in Power Query) auto generates step names using normal spaced words. This is great when reading the step names in this pane. There is, however, an unfortunate consequence of this naming style. The M Code is more difficult to read and write (although reading is the main issue I see).
Here is an image showing the difference in readability between the 2 approaches.
http://bit.ly/3IGgoQx
I understand Microsoft has a standard it follows, hence the spaced words in the name. Please give those that get in to the M code a toggle option to record these step names in camelCase. Actually, PascalCase may be better than camelCase.
- Comments (4)
RE: Provide a CamelCase toggle option for Applied Steps in Power Query
I am the opposite. I use #"" for all variable names, even those that do not contain spaces or special characters. I find this to be easier than needing to remember the 2 possible syntaxes. Also, the #"" adds some visual bulk that makes the variable names stand out a bit better. Whenever I see #"", I know that I'm looking at the name of a query, variable, column, or field. Lastly, #"" lets me write the variable name however I want without restrictions like needing to not use spaces or special characters. You are no longer forced to write like a programmer. You can write largely like you normally would and your code will still be valid, and I think that this is great.In the image that you shared, the camel-case step names in the pane are harder to read than the default names. The solution is not camel case. The solution is to have a way to get the effect of #"" while still being easy to type and easy to read. Maybe something like surrounding the variable name in single quotes is the solution (e.g. 'Variable Name').
RE: Provide a CamelCase toggle option for Applied Steps in Power Query
Voted & Posted on my social media accounts
RE: Provide a CamelCase toggle option for Applied Steps in Power Query
+1 vote
RE: Provide a CamelCase toggle option for Applied Steps in Power Query
Love the Idea Matt!I'll do my best to spread the word and get more votes on it!