Forum Discussion

Stuznet's avatar
Stuznet
Helper V
7 years ago
Solved

Vlookup from Another Table Return Value from Column

Please help, I'm currently struggling getting the same result from Excel in to Power BI. So basically I need to do a vlookup from table 1 and table 2 and returned result from Table 2 Column E and F. ...
Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    7 years ago

    Hi   Stuznet,

     

    In DAX you should use the LOOKUPVALUE formula (see documentation here):

     

    LOOKUPVALUE( Table2[CTR_Num, Table2[VI_Key], Table1[VI_Key])

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
7 years ago

Hi   Stuznet,

 

In DAX you should use the LOOKUPVALUE formula (see documentation here):

 

LOOKUPVALUE( Table2[CTR_Num, Table2[VI_Key], Table1[VI_Key])

Regards,

MFelix

Stuznet's avatar
Stuznet
Helper V
7 years ago

Thank you so much, it worked.