Measure for search number format in text

[selpaqm]

Hi,

I have 2 tables one of them has numbers, in second table has 2 different column and both of are free type cells, so i want to check this 2 columns for numbers in first table.  if this numbers exist in 2nd table it can say yes or no it doesnot mather.

ID Table

ID

233445

235667

236778

238990

2nd table 

id	Comment
233445/235667
123456	id cant find during phone call please use 238990vs235667 as id

after calculation in report i need to see below as table

ID	issue
233445	YES
235667	YES
236778	NO
238990	YES

[amitchandak · Accepted solution]

@selpaqm , Try new column like this in a new column

if(Countx(filter(Table2, CONTAINSSTRING(Table2[ID],Table1[ID])) ,Table2[ID])>0,"Yes","No")