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 ( CALCULATE...
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],
","
)
Works.... 🙊 Thank You so much for that.