How to Document DAX Measures in Excel
I often get asked if there is an easy way to create documentation for DAX measures when using Power Pivot for Excel. I am not a big fan of documentation for the sake of it, but I do see value in having “some” appropriate level of documentation. I think a good balance of the right amount of documentation vs the effort to write and maintain the documentation is to use the Power Pivot UI itself. I explain how I do it below.