Using Notepad++ as an editor for creating, reading, and troubleshooting DAX formulas
Rob recently wrote an article about the difficulty he experiences editing complex formulas in PowerPivot, even though he helped to create editor used in the Measure Settings dialog box. You can read Rob’s article here http://powerpivotpro.com/2010/03/27/two-observations/. In the article, Rob noted the following as shortcomings of PowerPivot’s built-in editor:
· Can’t indent formulas
· Can’t save formulas
· No find and replace option
· Can’t change the font size
To address these issues, Rob has been using Notepad as his PowerPivot formula editor.