Forum Discussion
Power bi Assistance.
okay so i have a very large data set that i'm trying to set up. i'm still not confident on the relationships yet. here goes. None of my tables were automatically set up from power bi. so i've have to do them manually. most work with many to many but it's not reading all of the data, hence i've started to do the work around with tables with uniques values, HOWEVER this is where i'm getting stuck.
What would need from me to assist? screen shots?
Hi Anonymous ,
I think bridge tables should help for your scenario, it can help you to mapping different table records more accurately.
You only need to extract same type fields(e.g product id, user id,etc...) from different tables and remove duplicate to use it as bridge to create one to many relationship to link these tables.
DAX Puzzle: Multiple many-to-many relationships
HOW TO JOIN MANY TO MANY WITH A BRIDGE TABLE IN POWER BI
Please understand that these links are provided with no warranties or guarantees of content changes, and confers no rights.
Regards,
Xiaoxin Sheng