concatenate a numeric column with text power query

Question

I want to make a new column in power query, and want to contanate a numeric column with extra text. I get an error when I try:

= Table.AddColumn(#"Added Custom1", "Custom.1", each Text.Combine({"Status", [ActivityID]}," " ))

or

= Table.AddColumn(#"Added Custom1", "Custom.1", each Text.Combine({"Status", Text.From[ActivityID]}," " ))

or

= Table.AddColumn(#"Added Custom1", "Custom.1", each Text.Combine({"Status", Number.ToText[ActivityID]}," " ))

I am open to suggestions!

My current work around is to change the data type to text, but this will cause issues later on

v-lili6-msft · Answer

hi, Anonymous
For two text column, you could use &amp; to concatenate them.
In your case, you want to concatenate a numeric column with text, so use&nbsp;Number.ToText Function add aformula as Interkoubess
And if you want to add a space between two field? if so you could try this
Table.AddColumn(#"Added Custom", "Custom.1", each [Status]&amp;" "&amp;Number.ToText([ActivityID]))

Result:

&nbsp;
If it is not your case, please share some data sample and expected output. Do mask sensitive data before uploading.Best Regards,Lin&nbsp;
&nbsp;

interkoubess · Answer

Hi&nbsp;Anonymous,&nbsp;Try this :&nbsp;Table.AddColumn(#"Added Custom1", "Custom.1", each [Status] &amp; Number.ToText([ActivityID]))I suppose&nbsp;[Status] is a column.&nbsp;Ninter&nbsp;