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]))))
)
)
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |