Formatting MDX and DAX: Free Online Tool From Microsoft

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 created by Mosha Pasumansky but it appears that link is dead leaving the Microsoft Labs tool the only contender.

Check it out:


By Phil Steffek

Phil Steffek is a professional sumo wrestler who is hoping to represent the U.S. in the next Olympics. During the off season Phil is a Data Architect working on transactional databases, data warehouse implementations, and all aspects of business intelligence. Also, Phil is not really a sumo wrestler. You can get to know a bit more about my non-sumo doings by checking out my LinkedIn Page

Leave a comment

Your email address will not be published.