Share via

what is the difference

David - 40 Reputation points
2023-09-28T02:21:01.1566667+00:00

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.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,253 questions

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,286 Reputation points
    2023-09-28T05:11:22.9333333+00:00

    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.

    1 person found this answer helpful.
    0 comments
  2. Luke 45 Reputation points
    2023-09-28T09:01:04.57+00:00

    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.

    1 person found this answer helpful.