Forum Discussion
searching for text in a separate table
Hi everyone, I need help in the following situation. I have two data sets that are not related to each other. The first one is actually a Bookings report by Order Number Order Number Custome...
amitchandak
Super User
Super UserCristinaB , Create a new column in table 1
if(countx(filter(Table2,search(Table[Order Number], table2[Order Number],1,0)>0), table2[Order Number])+0>0,"in CRM Cloud","not in CRM Cloud")
@amitchandak Thank you! i do get an error message and don't know exactly how should i proceed.
formula:
CRM ENg = if(COUNTX(FILTER(vwCRMOrders, search(Orders[Order Number], vwCRMOrders[Order Number],1,0)>0), vwCRMOrders[Order Number]+0>0), "in CRM Cloud", "not in CRM Cloud")
Error: The function COUNTX cannot work with values of type Boolean.
Any advice on what to do next ?