How to Format M Query Syntax

[AnkitBI]

@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 formatter,others) or we just need to right it the correct way.

Thanks,

Ankit Jain

[Zubair_Muhammad · Accepted solution]

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

[Zubair_Muhammad · Accepted solution]

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 · Accepted solution]

Same here, would love to see such a tool 😉

[AnkitBI]

@ImkeF  @Zubair_Muhammad 

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

[ppvinsights]

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