Wednesday, 14 October 2020

Power BI DAX - RELATIONSHIP IS many to many relationship which is currently not supported

 Hi All,

Error while creating relationship between two tables in SSAS tabular model - RELATIONSHIP IS many to many relationship which is currently not supported.


To resolve this, create a bridge table and then establish One to many and Many to One relationship between the tables.

You may use the below DAX query to create Distinct value


=DISTINCT(D_EXCHANGERATE[CD_FROMCUR])


Enjoy coding!



No comments:

Post a Comment