DAX with Tabular Model Series – Many to Many Relationship in Tabular Model, Achieve by DAX

Tabular model is completely different from Multidimensional in terms of storage, programming language or wait works and in the modeling part.

It is based on Relational Modeling. We have tables and relationships. In tabular model we can have one to one and one to many relationships. Analysis Services 2012 Tabular Model do not support many-to-many relationship in the native data model. However, We can achieve many-to-many relationship by writing a complex DAX expression.

In Multi dimensional model we have many to many relationship as a native relationship available in the model. We need to write complex DAX logic in order to achieve many to many relationship.

For calculations we are using calculated columns and defining measures !

I will post a Sample DAX example of how we can achieve many to many relationship via DAX in the next post

That’s all folks; I’ll see you soon with more “DAX” articles.

Thanks!

Pawan Kumar Khowal

MSBISKills.com