This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 93%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
I learned that there are two query languages, MDX and DAX. I want to ask which features they apply to and what is the difference?
Is it correct to add SSAS tag? Please let me know if this is not the correct tag.
Hi,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Hi @David -
You can refer to these two links.
https://www.quora.com/What-is-the-difference-between-DAX-and-MDX
https://www.wiseowl.co.uk/blog/s1450/dax-versus-mdx.htm
Best regards,
Percy Tang
what is the difference?
The query languages MDX and DAX are very different. They have similar logic, but completly different syntax.
What to learn? Depends on which type of SSAS (yes, the tag is right) you are going to use.
SSAS in classic multidimensional mode = MDX
SSAS in-memory tabular mode = DAX
Whereby tabular also supports MDX queries.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 27%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
MDX is mainly for querying OLAP databases, which are all about multidimensional data models.
It's great for handling data in cube formats, and if you're diving into measures, dimensions, and hierarchies in a cube, MDX is your go-to.
DAX is more for tabular models, like what you'd find in Power BI or SSAS Tabular.
It's super for creating custom columns and measures in Power BI, and it's a bit more intuitive if you're coming from an Excel background.
It wont let me delete this comment