Forum Discussion
Solved
Add column based on a list from another table
I have 2 tables (which are obtained via two separate queries): - In Details table I have columns like Date, Country, Customer, Text and some other columns - In Products table I have a list of pr...
Hi Croy
Try this calculated column in DETAILS table
Calculated Column = CONCATENATEX ( FILTER ( Products, SEARCH ( Products[Products], Details[Text],, 0 ) > 0 ), Products[Products], ", " )
I'm thinking you will want to use the DAX SEARCH or FIND functions to achieve what you are going after. Perhaps coupled with LOOKUPVALUE as well. Now that I am thinking about it, I don't generally reference other queries from a single query in M in the manner you are describing.
Hi Croy
Try this calculated column in DETAILS table
Calculated Column =
CONCATENATEX (
FILTER ( Products, SEARCH ( Products[Products], Details[Text],, 0 ) > 0 ),
Products[Products],
", "
)Croy this formual by zubai should give the result as u suggested
Awesome solution Zubair. Many thanks :)
Hi Zubair, if the text field contains multiple keywords the formula returns multiple categories. Anyway to just get the first one that matches.
