Forum Discussion
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 (
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 ?
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],
","
)
2 Replies
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],
","
)