Forum Discussion

jackjanice's avatar
jackjanice
New Member
5 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    jackjanice , Try a new column in Data table

    maxx(filter(RegionTag , search(RegionTag [region], Data[Tag],,0)>0)RegionTag[region])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

jackjanice , Try a new column in Data table

maxx(filter(RegionTag , search(RegionTag [region], Data[Tag],,0)>0)RegionTag[region])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak Hey Amit - are you able to help with below question. It is similar issue to above. But it is for Tabular Model DAX not PBI DAX. hence the solution here isn't working there. It throws error -

 

"The function MAXX takes an argument that evaluates to numbers or dates and cannot work with values of type String."

 

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Lookupvalue-for-a-Search-String-in-Tabular-Model/m-p/1892814#M40771