If you use PowerPivot and write some DAX formula, don’t miss this post on PowerPivotPro blog – if you want to get an external editor for your DAX formula, you can use Notepad++ for free – and adding the customization described in this post by Colin Banfield, you will get function auto-complete and tooltips.

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2010/04/07/notepad-used-as-dax-editor.aspx