Tools

Powerful DAX & Power Query editor

If you feel not very comfortable with DAX & Power Query editor, have a look at Visual studio code. It provides very efficient and powerful text functions including auto completion, Intellisense, advanced search & replace, …

You will edit your code in different tabs and keywords are coloured according to the language you use.

Much more extensions are available to edit other codes. For instance, you can edit C++, HTML, batch code. The list is long.

How to

  1. First, download Visual studio code : https://code.visualstudio.com/

2. And add DAX and Power Query extensions

3. Then enjoy

Additionaly, you will be able to save your favorite code and to create workspaces.

Though you will need to copy and paste your code from Power Query to Visual studio code and vice versa, you will save a lot of time. Above all, you will not need to close and open the advanced editor to check other pieces of code.

In conclusion, give it a try ! It’s worthy.