Forum Discussion

mocolega's avatar
mocolega
New Member
8 years ago
Solved

Create a string with all values of column

Hi!

 

I would like to know if it is possible to transform a column in a string. E.g:

 

Collumn A

Value 1

Value 2

Value 3

 

I need that the result will be something like: "Value 1; Value 2; Value 3"

 

Thanks!

 

  • Try this:

     

    Measure = CONCATENATEX(VALUES(Table[Collumn1]),[Collumn1],";") 

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Try this:

     

    Measure = CONCATENATEX(VALUES(Table[Collumn1]),[Collumn1],";")