Lookup for value of one column to another column in same table

[Anonymous]

Hi,

I have two columns which is column 1 and column 2 in same table. here, i want achieve that column 1 value look for the value in  Cloumn 2 , if it is matching then it should return "Yes" else "No". 

I am expecting similar to VLOOOKUP(Excel functionality) function in Power BI for same table.

Please help on this.

Thanks,

[quentin_vigne]

Hi @Anonymous

You can use a IF() function ?

If it doesn't work, can you please provide us a sample of you data so that we make it work ? 

Quentin

[Anonymous]

Hi I have the same scenario but in a direct query but lookupvalue contains, related doesn't work while creating a column.

Could you help me with driving this issue?

Thankyou

kng

Column1Column2

Table 1
	ID	ABC
	1	7683739
	2	8790111
	3	7683739
Table 2	Column1	Column2	Column3
	ID	ABC	Flag
	1	7649463	Yes
	2	7649463	No
	3	7635353	Yes

[Anonymous]

Hi Quentin,

Thanks for looking into this.

IF() function doen't work here. suppose if i wanted careate Tablular visual same as you see below.

Here , i have to create  calcualted field(Expcted Column) to do vlookup flag "Yes" if value of Column 1 is found Column 2, else "No" if value of Column 1 not found in Column 2 .

Column 1       Column 2        Expected Column

-----------     -------------      --------------------

 a1                     x1                      Yes

 b1                     y1                      No

 c1                     z1                       No

d1                      a1                       Yes

e1                      d1                      No

looking forward for your responce.

Thanks, 

Ganesh

[Hasan · Accepted solution]

you can try this formula

Expected Column = CONTAINS(Table1,Table1[Column 2],Table1[Column 1]).

[Anonymous]

Thanks Hasan...!

It's working.

Best Regards,

Ganesh