Forum Discussion
Solved
Search in a text column for values in another table using DAX
Hi experts, I have two tables, one is called "Data", there's a columns called "tags", the values in this column is comma separated strings, each string stands for a tag. Another table is called Regi...
jackjanice , Try a new column in Data table
maxx(filter(RegionTag , search(RegionTag [region], Data[Tag],,0)>0)RegionTag[region])
amitchandak
Super User
Super Userjackjanice , Try a new column in Data table
maxx(filter(RegionTag , search(RegionTag [region], Data[Tag],,0)>0)RegionTag[region])
Thank you amitchandak very much, this is exactly what I want!