BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Posted by Andy Brown on 22 February 2021
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.
DAX.DO - a replacement for DAX Studio?
Executive summary: probably not, but judge for yourself!
You may well find that you can manage without either DAX Studio or DAX.do now that the DAX editor in Power BI has improved so much.
First things first - what's DAX Studio?
DAX Studio is an open-source project begun by Darren Gosbell, who lives and works in Melbourne. It allows you to create DAX queries to run against your Power BI, PowerPivot or Analysis Services Tabular data models:
An example of a query in DAX Studio.
What is DAX.DO?
If you've tried to teach yourself DAX from a text book (hint: it's easier to learn from our Wise Owl course), the book was probably written by Marco Russo of SQLBI (probably in partnership with Alberto Ferrari). Now Marco has written a web-based DAX editor, which you can find at dax.do:
Like any website, this will run in any modern browser.
This includes a nice clean interface and lots of great features, all explained in a strong Italian accent (with lots of gestures) by Marco himself:
Marco explaining how to use DAX.do.
Advantages of DAX.DO relative to DAX Studio
There are two main reasons that I can see to use DAX.DO over DAX Studio:
|It's web-based||Because DAX.do is a website, you won't need to keep updating your software to get the latest features.|
|Sharing DAX online||You can publish measures that you've created to the cloud (well, to the SQLBI website), and even create a private link to them which will allow you to make changes while only letting others view your work.|
However, the two products have much more in common than they do differences: they both allow you to comment and indent DAX, they both make it easy to get help on DAX functions and they both let you click and drag on keywords to add them into your query.
The disadvantage of DAX.DO
Apart from the horrible name (sorry, but I immediately think of dog do or cat do), DAX.do suffers from one huge disadvantage - you can't link to your own data model (well, I can't see how to do it and the tutorial doesn't mention it):
DAX.do comes with two built-in data models installed (I presume) on the SQLBI server, but until I can upload my own data model and connect to that I'll stick to DAX Studio.
By contrast, DAX Studio asks you to connect to your own data model each time that you run it (it doesn't have a native database):
DAX Studio asks you to connect to a PowerPivot, Power BI or SQL Server Analysis Services data model.
One either tiny picky point: in DAX Studio you can run a query by pressing F5, whereas in DAX.do you have to press Ctrl + F5.