concatenate; Expression.Error: We cannot apply operator & to types Number and Text.

[bjha1]

Trying to concatenate in power query below coulmns to populate a key but getting error message. Kindly help.

Emp Code    Cost Center    Department

12345           BLR South      Procurement

Desired result: 12345 BLR South Procurement

[JadhavVarsha_13 · Accepted solution]

@bjha1 We cannot apply operator & to types Text and Number directly.

you can use  = Table.AddColumn(#"Changed Type1", "Custom", each Text.From([Emp Code]) &[#"Cost Center "]&[Department])

let me know if this helps !

[DOLEARY85]

Hi, 

it's probably due to one of your fields being a number, try:

Number.ToText([Emp Code]) & " " & [Cost Center] & " " & [Department]

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍