Matching column of names to column of notes

[Shiji]

Hi! What is the best way to compare a column of names with a column containing notes? If I were to just match names, I would build a relationship and use fuzzy match. However, since the second column contains sentences/paragraphs, fuzzy matching yields almost no results. Is there a best practice on how to do this? I'm thinking it involves a find/function and loop? Any help would be appreciated! Example columns are provided below.

Names

Ashok Kumar

Baby Doe

Brett Boe

Carla Coe

Frank Foe

Jackie Joe

Jane Doe

Jane Poe

Jane Roe

Joe Public

John Doe

Notes

Jane Poe had a little lamb

Jake was all business when he wore his clown suit.

A quiet house is nice until you are ordered to stay in it for months.

Writing a list of random sentences is harder than I initially thought it would be.

Best friends are like old tomatoes and shoelaces.

Seek success, but always be prepared for Joe Public.

They improved dramatically once Frank Foe left.

The small white buoys marked the location of hundreds of crab pots.

[v-yiruan-msft · Accepted solution]

Hi @Shiji ,

You can create a calculated column as below in Names table, please find the details in the attachment.

Notes = 
CALCULATE (
    MAX ( 'Notes'[Notes] ),
    FILTER ( 'Notes', CONTAINSSTRING ( 'Notes'[Notes], 'Names'[Names] ) )
)

CONTAINSSTRING

CONTAINSSTRING, CONTAINSSTRINGEXACT – finds text string in another text string (DAX – Power Pivot, P...

Best Regards