Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi all,
I am currenlty learing PowerBI and also attending training classes. Therefore, coming across more and more use cases. One of which I struggle right now on how to solve it. I hope someone can provide some help with:
I have two tables. A project table and a project member table. They are connected via the project id. Would like to have the name of the project manager in the project table as a new column.
Project Table:
project id | name |
1 | Implementation |
2 | Marketing |
Project Member
project id | name | role | isLead |
1 | John | Scrum Lead | No |
1 | Melissa | Project Manager | Yes |
1 | Sam | Project Manager | No |
2 | Jeff | Project Manager | Yes |
Expected Outcome
project id | name | project manager |
1 | Implementation | Melissa |
2 | Marketing | Jeff |
Does anyone know how to solve this? Any help is highly appreciated!
Thanks Oli
Solved! Go to Solution.