Question: What are the Differences between MDX and DAX?
- DAX is based on Excel based Expression language with a lower learning curve. MDX is based on a multidimensional concept where you can query a Cube to get dimensions and measures as results.
- MDX cannot be used to Query Direct Query Models, whereas DAX can. At the time of release, DAX could not be used to query Multidimensional Models.
- There are no named sets or calculated members in DAX. You can use calculated columns to create new fields in the data model. For MDX, it is designed for multidimensional functionalities like scopes and assignments.
- Advanced concepts like Parent-Child relationships, Many to Many, attribute relationships, key vs. Name etc. are possible in multi-dimensional concepts. DAX is mainly suited for model calculations and simple analytics.
If you are familiar with SQL more than the complex MDX expressions, the concept of using filtering and aggregating methods in DAX will be more familiar to you and your customers.
Also Read my Post on: What is DAX.Disclaimer: The Questions and Answers provided on http://interview.faceofit.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose.