cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrianSK Frequent Visitor
Frequent Visitor

Two columns with different values in one table pointing to a single column of another table.

Hi,

 

Two fields of project table, ProjectIntitator and ProjectManager has values of WorkerId from WorkerTable.

 

I need to display names of ProjectInitiator and ProjectManager, but the name field from Worker table will always display only one value...

 

I created a new table as WorkerTableMgr(WorkerTable) and pointed ProjectManager of project table to WorkerId in new table.

 

But I am trying to figure out if we can have any other way to achieve this instead of duplicating the whole table..

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Two columns with different values in one table pointing to a single column of another table.

Hi @BrianSK,

 

Based on my assumption, I created two sample tables like below:

ProjectTable                                        WorkerTable

1.PNG2.PNG

 

You want to display corresponding name from WorkerTable in ProjectTable, right? If so, please create calculated columns in ProjectTable as below:

Name of Intitator = LOOKUPVALUE('Worker Table'[Name],'Worker Table'[WorkerId],'Project  Table'[ProjectIntitator])

Name of Manager = LOOKUPVALUE('Worker Table'[Name],'Worker Table'[WorkerId],'Project  Table'[ProjectManager]) 

3.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Super User
Super User

Re: Two columns with different values in one table pointing to a single column of another table.

Hi,

 

Share a sample dataset and show the expected result.

austinsense Established Member
Established Member

Re: Two columns with different values in one table pointing to a single column of another table.

Here's one approach to get you thinking ... https://powerpivotpro0-my.sharepoint.com/personal/austin_powerpivotpro_com/_layouts/15/guestaccess.a...

 

The relationship between projects and workers is complex, it's many to many.

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast Smiley Happy
Community Support Team
Community Support Team

Re: Two columns with different values in one table pointing to a single column of another table.

Hi @BrianSK,

 

Based on my assumption, I created two sample tables like below:

ProjectTable                                        WorkerTable

1.PNG2.PNG

 

You want to display corresponding name from WorkerTable in ProjectTable, right? If so, please create calculated columns in ProjectTable as below:

Name of Intitator = LOOKUPVALUE('Worker Table'[Name],'Worker Table'[WorkerId],'Project  Table'[ProjectIntitator])

Name of Manager = LOOKUPVALUE('Worker Table'[Name],'Worker Table'[WorkerId],'Project  Table'[ProjectManager]) 

3.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BrianSK Frequent Visitor
Frequent Visitor

Re: Two columns with different values in one table pointing to a single column of another table.

Thanks a lot Yuliana !