Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
cretak
Frequent Visitor

Create new column based on multiple conditions from a related table

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 idname
1Implementation
2Marketing

 

Project Member

project idnameroleisLead
1JohnScrum LeadNo
1MelissaProject ManagerYes
1SamProject ManagerNo
2JeffProject ManagerYes

 

Expected Outcome

project idnameproject manager
1ImplementationMelissa
2MarketingJeff

 

Does anyone know how to solve this? Any help is highly appreciated!

 

Thanks Oli

1 ACCEPTED SOLUTION
dufoq3
Super User
Super User

Hi @cretak , add this as Custom Column in Project Table:

 

Table.SelectRows(#"Project Member", (x)=> x[isLead] = "Yes" and x[project id] = [project id]){0}?[name]?

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

View solution in original post

3 REPLIES 3
cretak
Frequent Visitor

Hi @dufoq3 ,

 

many thanks! Appreciate your help! It worked like a charm

You're welcome. Enjoy 😉


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

dufoq3
Super User
Super User

Hi @cretak , add this as Custom Column in Project Table:

 

Table.SelectRows(#"Project Member", (x)=> x[isLead] = "Yes" and x[project id] = [project id]){0}?[name]?

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors