DAX Editor for SQL Server going to CodePlex


Hi, today at my PASS session I gave a demo of a DAX Editor. This is a sample written by three testers on the Analysis Services team – Nick Medveditskov, Karen Aleksanyan, and Sergey Volegov. We will making this sample available on CodePlex as soon as we figure out how to push a magic publishing button. [update 11/3/2011 – we did it! The sample is at http://daxeditor.codeplex.com/]

The DAX Editor is a brand new extension to VS 2010. It’s totally unrelated to the MDX and DAX formatter already available.  In this new extension, the user can edit DAX queries.  The extension supports syntax highlighting, formatting, auto-complete for keywords, functions, tables, columns and measures, measures editing, error reporting, brace matching and some other features. The DAX Editor can be used to write standalone DAX queries or you can use the DAX Editor to extract measures from a BIM file, edit measures, and then save measures back to a BIM file.

The DAX Editor is a sample and it’s not a built in (or officially supported) product feature. You will be welcome to view the code and contribute to the project. The EULA for the sample will allow for code to be added and also redistributed.

Watch the Analysis Services Team Blog for progress on posting this sample. Once the sample is released, I will have a separate post here to walk you through some of the features.

Thank you again for Nick, Karen, and Sergey for putting this together in your “spare time”. You sure deserved all the applause in the room during the demo!

Comments (6)

  1. Anonymous says:

    Lol thanks for your kind words 🙂

  2. Anonymous says:

    Do you have an estimate on when we can expect the DAX Editor to be available in CodePlex?

  3. We have an unexpected roadblock. Sorry no ETA. Thanks

  4. We did it! the sample is at http://daxeditor.codeplex.com/. I updated the post as well with this info.

  5. Anonymous says:

    I have tested this editor in SSDT (VS 2010) , it appears not to work as documented 🙁

  6. Anonymous says:

    Hi my name is Mauro.

    I installed Microsoft sql Server 2012 trial version, to learn it and test.

    Now i use SQL SERVER 2008 R2.

    I am studying new features and especially TABULAR MODEL.

    I read about this useful DAX EDITOR.

    I downloaded it but when i run VSIX Installer , i receive an error  that tells about:

    It was not possibile install tha software to all products installed in your machine..

    Is this possible i receive this error because i have installed both vs 2010 and VS2012 ????

    Thanks if someone can help me…

    Regards in advance.