Forum Discussion

wkelly1002's avatar
wkelly1002
Frequent Visitor
8 years ago
Solved

Need help on how to create a VLOOKUP scenario using DAX

I am trying to replicate the same functionality of a VLOOKUP equation in Power BI.   Ex. So there are 2 spread sheets involved. One of the spreadsheets has a column that contains persons ID: "js100...
Need Help
Tips and Tricks
Tutorial Requests
  • ChrisMendoza's avatar
    ChrisMendoza
    8 years ago

    wkelly1002,

     

    LOOKUPVALUE ( ) should work for you I would imagine.

     

    Something like the following code:

     

    lookupName = 
LOOKUPVALUE(
    Table2[name],
    Table2[persons ID], Table1[persons ID]
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey wkelly1002

 

I made a quick video tutorial going over this method. The trick is to use the SEARCH function. Hopefully you will find it useful to your situation. Give it a watch!

 

https://www.youtube.com/watch?v=_bdHe3z_fVU

 

Thanks,

Parker