cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MK_Aqipa Frequent Visitor
Frequent Visitor

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])

 

Anyone has an idea how i can solve it?

 

thanks in advance,

regards

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ChrisMendoza Senior Member
Senior Member

Re: Power query - concatenate text columns

@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'

 

View solution in original post

2 REPLIES 2
Highlighted
ChrisMendoza Senior Member
Senior Member

Re: Power query - concatenate text columns

@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'

 

View solution in original post

MK_Aqipa Frequent Visitor
Frequent Visitor

Re: Power query - concatenate text columns

thanks for your fast reply....with two text columns it worked now 🙂

 

=Text.Combine({[FCURR],[TCURR]}," " )

 

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)