Sorry.This part of my post was misleading.
“I am looking for a way to compare values to identify possible duplicates.”
I’m looking for possibe duplicate outlets in my sales app that occur because of a slight spelling difference in the name.
“Forester’s Arms” Foresters" “Foresters Arms”
To check to see if a new outlet that is being added to the system is already there I am creating a slice that looks for outlets in the sytem already with the same postcode and then whether the first 4 letters of any of the outlets that share that postcode are CONTAINED in the new outlet name.
This wouldn’t be perfect but would identify the majority of the duplictates.
Rows (of the table Data Import - new outlets) to be included in the slice to have:
The same postcode as any of the outlets in the main table Full List Table[Post Code]
AND contain the the 4 letters/text in the column [Run Report] in the [Name] of the outlet.
I could separate the first 4 letters of the [Name] in the new outlet list as I have done for the existing outlets (in column [Run Report] and look for an exact match but thought CONTAINS might provide more coverage in terms of mispellings.
This works below
AND(IN([Post Code],Full List Table[Post Code]),IN([Run Report],Full List Table[Run Report]))