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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

BrianSK's avatar
BrianSK
Regular Visitor
8 years ago

Thanks a lot Yuliana !