Convert table into a string

[Vasili]

Thank you in advance!

I have a trable that changes based on a filter. I would like to get a string that lists the values in that table seperated by commas. For example, if my table said:

USA

PERU

Canada

I would like to see a string that says "USA, Peru, Canada". The table will never have more than 10 rows.

Thank you again!!

[tamerj1 · Accepted solution]

Hi @Vasili 

you can use CONCATENATEX. If the result to be displayed in a card visual for example you can iterate over the VALUES of the column 

CONCATENATEX (

VALUES ( TableName[ColumnName] ),

TableName[ColumnName],

", "

)

[Vasili]

Awesome, it works... thank you so much!