Forum Discussion
Solved
Comparing 2 different columns and returning specific value
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 no...
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.
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.