Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

concatenate a numeric column with text power query

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({"...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous

For two text column, you could use & to concatenate them.

In your case, you want to concatenate a numeric column with text, so use 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]&" "&Number.ToText([ActivityID]))

Result:

 

If it is not your case, please share some data sample and expected output. Do mask sensitive data before uploading.


Best Regards,
Lin