Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
you can try this formula
Expected Column = CONTAINS(Table1,Table1[Column 2],Table1[Column 1]).
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
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 |
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
you can try this formula
Expected Column = CONTAINS(Table1,Table1[Column 2],Table1[Column 1]).
Thanks Hasan...!
It's working.
Best Regards,
Ganesh
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |