Forum Discussion
Solved
Data 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...
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".
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".
This worked great, thank you!!