search data in a table

[Alfonso8]

Hello, we have an issue with our data table. We would like to search a data in a different table (like VLOOKUP in excel) in our Power BI desktop. How we could do it?

Thank you in advance.

[Greg_Deckler · Accepted solution]

You could use LOOKUPVALUE:

https://msdn.microsoft.com/en-us/library/gg492170.aspx

[jthomson]

It's easy to do but without knowing what your two tables are, how they're related and what end result you want it's hard to suggest the best way to go about it