560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Using DAX Studio or DAX Editor as add-ins to create measures in SSAS Tabular
Part one of a three-part series of blogs
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.
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:
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.
25 Aytoun Street