Comparing 2 different columns and returning specific value

[Satishbang]

I have 2 different tables with similar value in a specific column, i used "lookupvalue" and did the comparision; however it returns the same compared value if its available and incase the value is not there it returns specific value.

My requirement is:  When 2 columns are compared and if the value matches, it should return specfic value, if not, another value 

[v-chenwuz-msft · Accepted solution]

Hi @Satishbang ,

You can create some measures like this:

if find in table1 =if( [Column2] in VALUES(Table1[Column1]) , 1 , 0 )

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

@Satishbang  Try the LOOKUPVALUE dax by refering below link:

https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax

[amitchandak]

@Satishbang ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.\

check if needed

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8