Forum Discussion
benjamincoady
Helper I
7 years agoData Relationship Help!
Hi, Apologies for my probably rather naive question, I am new to PowerBI but am already loving the desktop app! Anyway, I am building a resource management tool using a Structured Excel Spr...
- 7 years ago
The easiest way would just be to link the tables by the project name. The only issue is if you have multiple lines with that same project name in each table. To get around, that you can create a "bridge" table. Just make a list of unique project names and then link both of the other tables to the "bridge".
TCarrasquillo
Helper II
7 years agoThe easiest way would just be to link the tables by the project name. The only issue is if you have multiple lines with that same project name in each table. To get around, that you can create a "bridge" table. Just make a list of unique project names and then link both of the other tables to the "bridge".
- benjamincoady7 years ago
Helper I
This worked great, thank you!!