Custom Column Error Power Query

[Anonymous]

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

Experssion.Error:We cannot apply field access tp the Type Text Details

Value =

Key=Product.

My Applied Steps

Source

Navigation

Change Type

Replace Value

Replace Value1

Added Custom

Concat 1(for input tab)

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Try using the following code for your custom column:

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

Pete