Forum Discussion

sarahhp's avatar
sarahhp
Frequent Visitor
9 years ago
Solved

Concatenate rows with filter

I don't come from a coding background but I'm trying to take a list of products associated with different companies and concatenate the products associated with each company into a single field.  My ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    sarahhp

     

    Please use a Measure not a column

     

    Look at this:

     

    Product List is a Measure

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

sarahhp

 

hi. Please try with this measure:

 

Product List= CONCATENATEX(Table, (Table[Product Name],","))

 

You can view like you want with a table visual.

 

Adding CompanyName and Product List.

 

 

 

sarahhp's avatar
sarahhp
Frequent Visitor
9 years ago

Thanks Victor. I'm getting an error msg - Operator or expression '( )' is not supported in this context.  With the outside brackets being highlighted.

 

Product List= CONCATENATEX(Table, (Table[Product Name],","))