Power Query Error when using Text.Combine

[WhaleWatcher222]

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.

[Kedar_Pande · Accepted solution]

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