Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
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.
@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?
I use 2 tables:
The main one contains thousands of transactions like:
Date | Name |
21/08/21 | LENTA-809 |
23/08/21 | LENTA-809 |
24/08/21 | BELAYA APTEKA ORDZH |
25/08/21 | MEDKLUB |
26/08/21 | STOLINYJ DOKTOR |
The second one (the helper table) contains the list of search strings, categories, and groups:
Search string | Category | Group |
apte | Drugstore | Health |
lenta | Suipermarket | Food |
doc | Drugstore | Health |
My need is to filter the upper table "Name" column with the "Search strig" from the second one and use "Category" and "Group" columns.
I cant use relations between the tables because I need sort of "CONTAINSSTRING" solution.
Thanks in advance.
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
It works for me!! thanks a lot to share it!!
So there is no way to do it via measure?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |