Ever cut and paste a mess of generated MDX from Excel? How about a coworker who doesn’t know how to use the “tab” key when working in SQL Server Management Studio? I came across this no frills online MDX formatter from “Microsoft Labs” and have been using it for the last few days to clean up my own MDX as I’m writing it. I haven’t used it with any DAX but it’s fairly serviceable for MDX.
The tool is super simple to use. Paste your MDX into the top window, press “format”, and copy your code from the bottom window.
Note: I found a few references online to a tool at mdx.mosha.com created by Mosha Pasumansky but it appears that link is dead leaving the Microsoft Labs tool the only contender.
Check it out: formatmdx.msftlabs.com