Forum Discussion

Vasili's avatar
Vasili
Frequent Visitor
4 years ago
Solved

Convert table into a string

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's avatar
    tamerj1
    4 years ago

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

    ", "

    )

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    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's avatar
      Vasili
      Frequent Visitor
      4 years ago

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