Forum Discussion
Solved
Power Query Error when using Text.Combine
Hi Experts
I am getting a error with the following in Power Query and cannot see why
Text.Combine({"PO",[Order Num]})
The end result should PO123123 but Power Query is not liking it.
The issue is likely that the Order Num column is being treated as a number, and Text.Combine expects both inputs to be text. You need to ensure that [Order Num] is converted to text before combining it with "PO"
Try the following corrected formula:
Text.Combine({"PO", Text.From([Order Num])})If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande
1 Reply
The issue is likely that the Order Num column is being treated as a number, and Text.Combine expects both inputs to be text. You need to ensure that [Order Num] is converted to text before combining it with "PO"
Try the following corrected formula:
Text.Combine({"PO", Text.From([Order Num])})If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande