Forum Discussion

Nukkumatti's avatar
Nukkumatti
Regular Visitor
9 years ago
Solved

Problem to get third column value using two other columns

Hello,   I have following issue. I have two tables with following information Table 1       PanelID ReaderID Name   1 1 Reader 1   1 2 Reader 2   1 3 Reader 3   1 ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    hello Nukkumatti

     

    Create a calculated column with this dax:

     

    Name = LOOKUPVALUE(Table1[Name],Table1[PanelID],Table2[PanelD],Table1[ReaderID],Table2[ReaderID])

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

hello Nukkumatti

 

Create a calculated column with this dax:

 

Name = LOOKUPVALUE(Table1[Name],Table1[PanelID],Table2[PanelD],Table1[ReaderID],Table2[ReaderID])

Nukkumatti's avatar
Nukkumatti
Regular Visitor
9 years ago

Thank you Vvelarde. Worked perfectly! :)