Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi.
Can someone help me here. I have two tables. Table1 value should try to match with table two.
Table 1 values found in table 2 then yes else no.
Table 1
123456 | yes |
456789 | yes |
741321 | No |
159753 | No |
147852 | Yes |
Table 2 | |
147852 | |
65 | |
23 | |
123456 | |
456789 |
Solved! Go to Solution.
Hi, @Anonymous
I assume you want to create a new column in Table1
Please check the below picture and the formula for creating a new column.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
I assume you want to create a new column in Table1
Please check the below picture and the formula for creating a new column.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Anonymous
you can try this
Column =
var lookup=LOOKUPVALUE('Table (2)'[column],'Table (2)'[column],'Table'[Column1])
return if(ISBLANK(lookup),"no","yes")
Proud to be a Super User!
Hello,
Can you create a relationship between both Table1 and Tabl2 and then add a calculated column in Table 1 using "RELATED" fucntion?