SEARCH FUNCTION WITH A LIST VALUE COMMAS

[Anonymous]

Hi guys,

I found answer for that : we have 2 lists. Now we want to check if list 1 contains any value from list 2. 

which values in list are in current value? =

CONCATENATEX (

    CALCULATETABLE (

        VALUES ( List[Keyword] ),

        FILTER ( List, SEARCH ( List[Keyword], 'Messy names'[Name], 1, 0 ) > 0 )

    ),

    [Keyword],

    ","

)

My question is how to display which values in list are NOT in current value? Any idea please ?

[Anonymous]

Works.... 🙊 Thank You so much for that.

[tamerj1 · Accepted solution]

Hi @Anonymous 

nice code. Well done 👍. I think you just need to replac > with =

CONCATENATEX (

    CALCULATETABLE (

        VALUES ( List[Keyword] ),

        FILTER ( List, SEARCH ( List[Keyword], 'Messy names'[Name], 1, 0 ) = 0 )

    ),

    [Keyword],

    ","

)