Forum Discussion
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...
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 !
JadhavVarsha_13
Helper V
Helper Vbjha1 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 !