Power Query best practices

Power Query best practices: name queries and steps clearly, filter and remove unnecessary columns early, type correctly, avoid hard-coded values, isolate sources in parameters, and keep intermediate queries out of the model. They make the processing readable, fast and maintainable.

Example

Rename the step "Custom1" to "Added total".

Related concepts

The whole glossary