Forum Discussion

Anand2's avatar
Anand2
New Member
2 years ago

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...
General Comment
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anand2 

As tharunkumarRTK  mentioned ,you can consider to use brige table.

1.You can summerize the  project number to new table, then create relationship aomong the tables.

e.g 

Table =
SUMMARIZE ( 'Table', [project number] )

2.Crete relationship among the tables.

e.g Table[project number]->cube table[project number] (one to many)

Tale[project number]-> all pid [oracle pid ](one to many)

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.