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
Icon for Community Champion rankCommunity Champion
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
Icon for Community Champion rankCommunity Champion
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