Forum Discussion
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({"...
Interkoubess
Solution Sage
Solution SageHi Anonymous,
Try this :
Table.AddColumn(#"Added Custom1", "Custom.1", each [Status] & Number.ToText([ActivityID]))
I suppose [Status] is a column.
Ninter
- Thanks for the reply. Actually, "Status" is free text. The pivoted columns are all numeric, and after pivoting becomes fields called 1,2,3...
- Interkoubess
It also works with free text.
Ninter