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

Ara_Karapetyan's avatar
Ara_Karapetyan
Helper I
4 years ago

I am not sure.

I use two tables: one with transactions, another one is helper table with additional info. I need to find a part of text value from the helper table within transaction name text column in transation table and get all the corresponding fields from the helper.

 

Thank you in advance!

goncalogeraldes's avatar
goncalogeraldes
Super User
4 years ago

Ara_Karapetyan Depending on wether you have a relationship between both tables you can either use the RELATED() function or the LOOKUPVALUE(). Can you provide some sample data please?