Cast a column to a different type in PowerQuery

0
votes

I have the following query to combined two fields of different types:

= Table.AddColumn(#"New Column", "Calculated Column", each [Age] + [#"New-Name"])

Age is a number, and New-Name is a text field. However, I would like to cast the Age to a text field to concatenate the two fields together. How would I do this?

1
powerquerym

1 Answers

1
votes

Try this

= Table.AddColumn(#"New Column", "Calculated Column", each  Text.From([Age]) & [#"New-Name"])

Text.From to cast as text

& to concatenate