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.
- 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.
Phil Seamark provides a powerful solution to connect Visual Studio Code to your model : https://dax.tips/2020/07/09/using-visual-studio-code-with-power-bi/
Ben Gribaudo provides a powerful solution to connect Visual Studio Code to Power Query (M) code : https://bengribaudo.com/blog/2020/07/16/5356/editing-report-spreadsheet-mashups-in-vscode
In conclusion, give it a try ! It’s worthy.
Tabular editor website : https://tabulareditor.github.io/
BI Developer Extensions (previously BIDS Helper)
A Visual Studio extension that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDT).
SQL Server Analysis Services Tabular Protocol
Documentation of the Microsoft SSAS APIS