Forum Discussion
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!
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
8 Replies
Ara_Karapetyan Please provide more information or a sample of what you need. Do you need a LOOKUPVALUE()? An IF() statement? A SWITCH()?
Please refer to this article on how to post your answers in the best way
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!
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?
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.
