Looking for duplicate entries

[Phil_Waite]

Hi,

I am looking for a way to compatre values to identify possible duplicates.

I have an expression that just doesn’t seem to work when it should.

Name column in one table has

“Broadstraik Inn”

The column Run Report has

“Broa”

This expression doesn’t seem to give a positive.

CONTAINS([Name],Full List Table[Run Report])

I can get IN to work but not CONTAINS.

Screen shot below with Broa in the list.

Thanks

Phil