Forum Discussion

AnkitBI's avatar
AnkitBI
Icon for Solution Sage rankSolution Sage
7 years ago
Solved

How to Format M Query Syntax

ImkeF   Zubair_Muhammad  Others   Hi - How can we format M-Query syntax in proper way. I searched but couldn't find any reliable answer.  Is thery any available Tool like we have for DAX (DAX for...
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Hi AnkitBI 

     

    I am not aware of tool like DAX formatter for Power Query/M.

     

    I use help from gridlines in the Advanced Editor to do some code alignments

  • ImkeF's avatar
    ImkeF
    7 years ago

    Same here, would love to see such a tool ;)

AnkitBI's avatar
AnkitBI
Icon for Solution Sage rankSolution Sage
7 years ago

ImkeF  Zubair_Muhammad 

So all these beautifully crafted queries manually :) Thanks for Acknowleging and replying.

ppvinsights's avatar
ppvinsights
Icon for Helper III rankHelper III
6 years ago

Hi all,

 

even if the post is not the newest - we developed a Power Query Formatter. You find it here

https://powerqueryformatter.com

If offer an API as well if you want to use it on your websites/blogs.

If you find any issues do not hesitate to send a bug report.

 

Holger