Forum Discussion

BrianSK's avatar
BrianSK
Regular Visitor
8 years ago
Solved

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

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

4 Replies