Closest-match Lookup in a measure

[wolfgangkb-work]

I am extending a Harepoint dataset with coloums like 

Site Url | Sites Page =

CALCULATE (

SELECTEDVALUE ( 'Dimension Site Collection'[Url] )

& SELECTEDVALUE ( 'Dimension Site'[Site Collection Relative Url] ),

'Dimension Site'

)

I need to make a match on PARTS of the SITE URL in this column and match it to an area code.
My Lookuptable has two rows URL and CompanyID (which has a relation to another table with ID and NAME)

How can I add a column with the companyname (or ID) that matches teh URL closest? I suppose CONTAINSSTRING can help but I dont know how to build a measure with that.

So I need the closest-match lookup of "CompanyID" for my "URL"... Any hints are very appreciated

[v-easonf-msft]

Hi, @wolfgangkb-work 

Containsstring is usually used to determine whether a string contains another string.

If the strings differ greatly, please try @Greg_Deckler 's solution.

If it doesn't work, please share your sample file for further research.

Best Regards,
Community Support Team _ Eason

[Greg_Deckler · Accepted solution]

@wolfgangkb-work Well, there is a fuzzy matching option in Power Query that allows the use of a lookup table or I invented a DAX fuzzy matching measure here: Fuzzy - Microsoft Power BI Community