Power Query is a great part of Power BI. Recently I found myself building long power query scripts in Power BI. I wasn’t as methodical as I should have been and so the scripts got fairly messy. I’ve developed the following workflow order to improve readability and maintainability in my data preparation.
All steps are done left to right…
1) Split any fields that need to be split.
2) Delete any fields that are not needed.
3) Rename fields as needed.
4) Replace any values as needed.
5) Convert any field types as needed.
6) Add any new columns at the right.
Remember that fewer columns mean faster results. Consider using a calculated measure instead.
Jeff Albro / Beantown Data 