BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
The built-in DAX formula editor in SSAS Tabular leaves a lot to be desired. This blog shows how to install and use two of the most useful third-party add-ins: DAX Editor and DAX Studio.
Posted by Andy Brown on 11 January 2016
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Editing DAX expressions - available tools
SSAS Tabular is an excellent product, but even its best friends couldn't claim that editing measures written in DAX is easy!
You can use square brackets and apostrophes when typing to make creating measures easier, but it's not by any means a state-of-the-art editor.
Fortunately there are some third-party tools available to help you; unfortunately, they all seem to have their foibles! This blog looks at two which should be useful:
|DAX Studio||A separate program which allows you to edit beautifully formatted DAX expressions.|
|DAX Editor||A program built into Visual Studio, which (in theory at any rate) allows you to create expressions by typing them in as text.|
A couple of disclaimers for this blog:
- I've given my personal experiences. I've spent a fair bit of time evaluating the products, but wouldn't promise to know them as well as SSAS Tabular.
- I'm writing this blog in January 2016. It will eventually become obsolete, as new and better tools hit the market.
My recommendation would be to try DAX Editor first. If you can get this working properly (I can't), use it; otherwise, install and use DAX Studio.
Of course, the ultimate "better tool" would be to improve the DAX editor provided as part of Visual Studio. PowerPivot (SSAS Tabular's baby sibling) tries to provide a better editor, but doesn't succeed.