Before we look into what are the differences between MDX and DAX, let’s understand their purpose. Both MDX and DAX are an expression based language designed to query an SSAS Cube. To keep things simple, MDX is used to query multi-dimensional SSAS models, whereas DAX is used for Tabular Data Models. However, in Visualization tools like PowerBI, which primarily uses Tabular Data Models, can also query Multi-Dim models too.
While on paper they might be simple expression languages, the code can get quite complex and lengthy. However, both of these uses inputs and gives you a calculated output for your analytical model. So, let’s jump in and understand the main highlights below:
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.
Comments are closed.