Solved: Custom Column Error Power Query

Anonymous · ‎03-15-2021

Hi Experts

i am trying to concatenate a few column via a custom column in Power Query - cannot see the error.

= [Brand]&"-"&[BB]&"-"&[Product]

its says no syntax error have been detetcted...

When i click OK and go to the custom column the error mesaage is

My Applied Steps

Source

Navigation

Change Type

Replace Value

Replace Value1

Added Custom

Concat 1(for input tab)

BA_Pete · ‎03-15-2021

Hi @Anonymous ,

Try using the following code for your custom column:

Text.Combine({[Brand], [BB], [Product]}, "-")

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

BA_Pete · ‎03-15-2021

Hi @Anonymous ,

Try using the following code for your custom column:

Text.Combine({[Brand], [BB], [Product]}, "-")

Pete

Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Custom Column Error Power Query