Forum Discussion

Ara_Karapetyan's avatar
Ara_Karapetyan
Helper I
4 years ago
Solved

Text search

Hi everyone,   I need to search text Table[Column] within text Table2[Column] and return text value of Table2[Column]. How to make the measure? Please Help!
Need Help
  • goncalogeraldes's avatar
    goncalogeraldes
    4 years ago

    Hello there Ara_Karapetyan ! I think it would be best for you to perform these actions in Power Query rather than a measure. Open the Query Editor and add a custom column. In the pop up window paste the following code.

    Try this for the category column:

     

    =let myvalue=[Search string]
in
Text.Combine(
    Table.SelectRows(SecondTable,
each Text.Contains(myvalue,[Name]))[Category]
,
",")

     

     And this for the group:

     

    =let myvalue=[Search string]
in
Text.Combine(
    Table.SelectRows(SecondTable,
each Text.Contains(myvalue,[Name]))[Group]
,
",")

     

      

    Hope this answer solves your problem! If you need any additional help please tag me in your reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
    Thanks!

    Best regards,
    Gonçalo Geraldes

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Ara_Karapetyan ;

According to my understand, you could create a measure .

flag = VAR _A=SUMMARIZE('Table',[Column])
RETURN IF(MAX([Column]) IN _A,1,0)

Then apply it into filter.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.