Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Find text string in another table

Hello all,   Our customer is creating tickets in their ticket system, which we mirror in our own ticket system.   The data of our customer looks as follows: SummaryCustomer DescriptionCustom...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    Anonymous,

     

    Try this calculated column in InternalTable:

     

    Source = 
VAR vTable =
    FILTER (
        CustomerTable,
        VAR vCustomerValue = CustomerTable[SummaryCustomer]
        RETURN
            CONTAINSSTRING ( InternalTable[Summary], vCustomerValue )
    )
VAR vResult =
    IF ( COUNTROWS ( vTable ), "Customer", "Internal" )
RETURN
    vResult

     

     

DataInsights's avatar
DataInsights
Super User
4 years ago

Anonymous,

 

Try this calculated column in InternalTable:

 

Source = 
VAR vTable =
    FILTER (
        CustomerTable,
        VAR vCustomerValue = CustomerTable[SummaryCustomer]
        RETURN
            CONTAINSSTRING ( InternalTable[Summary], vCustomerValue )
    )
VAR vResult =
    IF ( COUNTROWS ( vTable ), "Customer", "Internal" )
RETURN
    vResult