How to use contains when searching two tables

I need to use CONTAINS to search in Table A a column value and compare it to a column value in Table B.

Is this possible?

I have this and it obviously is not working:
SELECT(Rental Tickets[Min_Start_Date],
AND(
[Customer_Name]= [_THISROW].[Customer_Name],
Contains([Ticket_Action], “On Rent”,
CONTAINS(Rental Tickets([Item_List], [_ThisRow].[Inventory_Item_ID]= [Inventory_Item_ID]))))
)
)

0 22 184
22 REPLIES 22
Top Labels in this Space