Comparing string similarity of two columns in different tables

[Anonymous]

Hello everyone,

I have a problem that needs to be solved. I need to be able to compare two columns in two different tables and see if there are similar strings within those two columns. So for example if I would like to compare a list of my friends to the most wanted lists of the FBI, I could do that.

So the pseudo code would look something like this:

For name in name_column in myfriends_table:

     Compare the similarities of every name in myfriends[name_column] to the FBI's most wanted list name_column

     return values that have similarities over 40%

Below I have a demonstration for my issue.

My Friends

Name

TJ Watt

Minkah Fitz

Juju Smith-Schuster

Big Ben Roeth

FBI's Most Wanted

Name

TJ Hatt

Juju Smith-Schuster

Juju Smith

Cam Heyward

Big Ben Roeth

Results table

My Friends Name	FBI's Most Wanted Name	Similarity
TJ Watt	TJ Hatt	83,333%
Juju Smith-Schuster	Juju Smith-Schuster	100%
Juju Smith-Schuster	Juju Smith	46,67%
Big Ben Roeth	Big Ben Roeth	100%

Is it possible in dax?

Kind regards,

Jeppe

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

You'd better first create a summarized table such as below:

As if you directly compare the characters from 2 tables,the calculation would be created in the table below: 

After you get a summerized table,you could refer to below similar thread to realize what you need.

https://community.phttpsi.com/t5/Deskpowerbipare-t5o-strings-for-similarity/m-p/290062

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[v-kelly-msft · Accepted solution]

Don't @jeppevatane,

Have you checked my answer? Is your problem solved?

Saludos
Kelly

Have I answered your question? Mark my position as a solution!

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

You'd better first create a summarized table such as below:

As if you directly compare the characters from 2 tables,the calculation would be created in the table below: 

After you get a summerized table,you could refer to below similar thread to realize what you need.

https://community.phttpsi.com/t5/Deskpowerbipare-t5o-strings-for-similarity/m-p/290062

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!