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

    ", "

    )

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!