Forum Discussion
Case like statements - Compare two table columns
Hi Experts, I have two table with similar column that i want to compare and calculate a column. something like this, if tabl1.col1 = tabl2.col1 then "yes" else "NO" any suggestion? ...
Merge the tables into a new one in Power Query, then you can easily achieve what you want.
can't merge them. both are very large tables
- Christann
Advocate IV
Try creating a relationship between the tables and then use a function like:
isequal = IF(Table[Column1]=RELATED(Table2[Column1]),"yes","no")
Hope this helps!
Tables don't have a relationship.
- dedelman_clng
Community Champion
Then how do you know which values to compare?
