Forum Discussion
WhaleWatcher222
Helper II
Helper IIPower 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
Kedar_Pande
Super User
Super UserThe 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])})