Transform Data from SharePoint List

[gaccardo]

I have a table with a single column, and what I would like to do is transfrom this into a single, comma-separated value,

like this 883673,883674,883678...  How can I do this?

[donsvensen]

Hi

In Power Query you can do use the Text.Combine

= Text.Combine(Table1[Column1.id],",")

In DAX you can create a measure with CONCATENATEX

Measure = CONCATENATEX(Table1,[Column1.id],";")

/Erik

[gaccardo]

Thank you very much for the solution.  When I use the following expression:

    #"Combine" = Text.Combine(workItemTable[Column1],",")

I get the following message:

Expression.Error: We cannot convert a value of type Record to type Text.
Details:
    Value=Record
    Type=Type

What have I missed?

Best Regards,

G

[donsvensen · Accepted solution]

Hi,

The first item in your Text.Combine must be a list and not a table of records so you need to convert your

workItemTable[Column1]

to a list

https://msdn.microsoft.com/en-us/query-bi/m/table-tolist

Table.ToList(workItemTable[Column1])

/Erik