Forum Discussion
Compare text (names) in two columns in the same table
Hello I want to compare the names in the column 1 and column 2 of the same table. Let's say A B John Carry Carry John Ivan Mathew Ro...
Since the fuzzy join did the match for you, just use a formula like this:
if [column1] = [column2] then [column1 phone] else [column2 phone]This assumes you brought in both phone numbers from these two tables.
Thank you edhans for your reply but that did not work. I tried it before and I forgot to mention it in the question. Although I found a solution in my case, I believe there should be a general solution for this problem.
edhans
Community Champion
Community ChampionNot sure what you are proposing the general solution is to be. It would seem to me some AI would need to be invoked to read those names and do the comparison, and that isn't possible at that level right now. There is some AI functionality in Power BI Premium workspaces, but I've not played with it as of yet.