Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
4 years ago

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

  • mb0307 ,

    I think you can create a measure with concatenatex that would be better

     

    concatenatex(Table, Table[Column])

    • mb0307's avatar
      mb0307
      Responsive Resident

      amitchandak  Thanks Amit but as mentioend this needs to be done in Power Query please.