Vlookup column in power bi using text values

[Anonymous]

Hello,

I must be missing something here, so if anyone can assist - it would be greatly appreciated. In the query editor, I would like to create a new column like the "result" below. I can do this very simply in excel, but I am struggling in Power BI because they are all text columns. Hoping someone smarter than me can help! 

=VLOOKUP(A2,B:B,1,FALSE)

A              B             C

Prod Raw Mat Result

Prod	Raw Mat	Result
X	A	#N/A
Y	Z	#N/A
Z	B	Z

[Pragati11]

Hi @Anonymous ,

Rather than doing this in Query Editor in Power BI, create a calculated column using LOOKPVALUE function.

Check the following link on this DAX function as follows:

https://www.c-sharpcorner.com/article/dax-in-power-bi-how-to-use-lookupvalue-function/

Thanks,

Pragati

[Anonymous]

Thanks for the quick response, the problem I have is all of my columns are text columns. The "Search_Value1" (as shown below) is only allowing me to grab a measure from my measures table, it won't allow me to take a column from my 'Formula_master' table. Is it possible to create a custom or calculated column?

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Are you creating a measure using LOOKUPVALUE function?

If yes, then don't do that. Create a column and then use LOOKUPVALUE function.

Thanks,

Pragati

[Anonymous]

Do you by chance know why it is telling me that "A table of multiple values was supplied where a single value was expected"? My data may have instances where there are multiple texts that are the same in each column. 

[Anonymous]

Nevermind I got it! Thank you for all your help!