Free tools
Free Power Query (M) formatter
Paste your formula, press Format and copy it ready for Power BI. It runs in your browser: your code is never sent to any server.
Your code
Ctrl + Enter
Result
The formatted, color-coded code appears here.
What does the formatter do?
- Writes functions and keywords in uppercase (CALCULATE, VAR, RETURN...).
- Keeps on one line what fits and splits long functions into several lines, one argument per line.
- Arranges VAR and RETURN blocks and keeps your comments.
- Warns you if a parenthesis, a text or a column name is not closed. Click a function in the result to see its documentation.
- Uses Microsoft’s official Power Query formatter (the same engine as the Power Query editor for Visual Studio Code).
- Puts each let step on its own line and arranges lists, records and nested functions.
- If the query has a syntax error, it tells you on which line and column.
Are your reports ready? Share them without paying a license per person.
Vitrecia publishes your Power BI dashboards in a portal with your brand for your team, your clients and your partners.