Forum Discussion

Croy's avatar
Croy
Regular Visitor
8 years ago
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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Croy

     

    Try this calculated column in DETAILS table

     

    Calculated Column =
CONCATENATEX (
    FILTER ( Products, SEARCH ( Products[Products], Details[Text],, 0 ) > 0 ),
    Products[Products],
    ", "
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Croy

 

Try this calculated column in DETAILS table

 

Calculated Column =
CONCATENATEX (
    FILTER ( Products, SEARCH ( Products[Products], Details[Text],, 0 ) > 0 ),
    Products[Products],
    ", "
)
ysaykin's avatar
ysaykin
New Member
5 years ago

Hi Zubair, if the text field contains multiple keywords the formula returns multiple categories. Anyway to just get the first one that matches.