Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 !
@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 !
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 👍