Forum Discussion

bjha1's avatar
bjha1
Regular Visitor
3 years ago
Solved

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

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   Des...
Need Help
  • JadhavVarsha_13's avatar
    JadhavVarsha_13
    3 years ago

    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's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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 👍