Forum Discussion

MK_Aqipa's avatar
MK_Aqipa
Frequent Visitor
8 years ago
Solved

Power query - concatenate text columns

Hi, I need to combine two text columns. I've tried it in the custom column with the & Formuala, but I get an error.  = Table.AddColumn(#"Geänderter Typ", "Text.Combine", each [FCURR]&[Period])   ...
Need Help
Tutorial Requests
  • ChrisMendoza's avatar
    ChrisMendoza
    8 years ago

    MK_Aqipa,

     

    is [FCURR] and [Period] of type Text? What is the error you get?

     

    Also, where is your function Text.Combine( )? It looks like you've just joined with '&' which should give you something like:

     

    [Column1]&[Column2]

outputs 'helloworld'
    Text.Combine({[Column1],[Column2]}," " )

outputs 'hello world'

     

Rickmaurinus's avatar
Rickmaurinus
Icon for Helper V rankHelper V
3 years ago

The trick when concatenating values is to make sure they are of the Text sort. 

 

So either:

- Make sure the entire column is text

- Use a function that transforms the value to text during the evaluation. 

 

I think anyone struggling with this may enjoy this article: 

 

https://gorilla.bi/power-query/concatenate-values/

 

Also take into account that referencing null values may result in different values.

 

--------------------------------------------------

 

@ me in replies or I'll lose your thread

 

Master Power Query M? -> https://powerquery.how

Read in-depth articles? -> BI Gorilla

Youtube Channel: BI Gorilla

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly.