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],
    ", "
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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.

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],
    ", "
)