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], ", " )
Hi Croy
Try this calculated column in DETAILS table
Calculated Column =
CONCATENATEX (
FILTER ( Products, SEARCH ( Products[Products], Details[Text],, 0 ) > 0 ),
Products[Products],
", "
)
Awesome solution Zubair. Many thanks :)