Forum Discussion
Transform Data from SharePoint List
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?
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
3 Replies
Hi
In Power Query you can do use the Text.Combine
= Text.Combine(Table1[Column1.id],",")
In DAX you can create a measure with CONCATENATEXMeasure = CONCATENATEX(Table1,[Column1.id],";")
/Erik
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=TypeWhat have I missed?
Best Regards,
G
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
