Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

SEARCH FUNCTION WITH A LIST VALUE COMMAS

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 ( CALCULATE...

tamerj1
4 years ago
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],
    ","
)

Icon for Community Champion rank

Community Champion

4 years ago

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],

","

)