Forum Discussion
mb0307
4 years agoResponsive Resident
Text.Combine single column - in power Query
Hi all,
I want to concatenate all values in a column with " prefix and suffix and ,
Example:
Column1
3000
2000
7777
I want result to be: "3000", "2000", "7777"
I will be using this in Power Query as Input like this:
{Cube.ApplyParameter, "[!V99]", {{ Text.Combine ( CODE ) }}}
Thank you!
2 Replies
- amitchandakSuper User
mb0307 ,
I think you can create a measure with concatenatex that would be better
concatenatex(Table, Table[Column])
- mb0307Responsive Resident
amitchandak Thanks Amit but as mentioend this needs to be done in Power Query please.