Forum Discussion
Need to Fetch one column data from one table to another table which have many to many relationship.
I have 2 tables loaded in power Bi named "cube table" and the "all pid" table. so now in the cube table i have project number and in the all pid table i have oracle pid which are related by many to m...
tharunkumarRTK
Super User
Super UserAnand2
many to many relationship is not a good pratice. I would suggest you to create a bridge table https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many#relate-many-to-many-dimensions to avoid such relationships.
Then you will be able to use related dax function to retrieve one side value to many side and relatedtable for vise versa.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun