How to Convert Column Into Delimited List

[Anonymous]

Hi Community,

I want to Convert Column into List. Please find below details.

Dataset = Select Distinct ids from table

Output of dataset:

IDs

123

456

789

So i want to display these values in taxtbox as 123,456,789

Thanks,

Pravin

[Fowmy]

@Anonymous 

You can create a measure as follows and use it on a card visual:

ID List = 

CONCATENATEX (
    DISTINCT (tablename[IDs]),
    tablename[IDs],
    ", "
)

[Anonymous]

@Fowmy  I want it in power Bi Report Builder not in Power BI Desktop.

Thanks,

Pravin