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
Search our website
We also send out useful tips in a monthly email newsletter ...
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.
This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources. |
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:
Tool | Notes |
---|---|
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.
Parts of this blog |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2023. All Rights Reserved.