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

[BrianSK]

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..

[v-yulgu-msft · Accepted solution]

Hi @BrianSK,

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

ProjectTable                                        WorkerTable

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]) 

Best regards,
Yuliana Gu

[BrianSK]

Thanks a lot Yuliana !

[austinsense]

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.

[Ashish_Mathur]

Hi,

Share a sample dataset and show the expected result.