Forum Discussion
Concat Text + Colum power query
Hi all.
Need to create a new collumn with text + Collumn + text + Colum
Example:
Table
Column: Year 2014, 2015, 2016, 2017, 2018
Column: Order 12,13,14,15,16,17...
New Column with "http:mywebsite.com" + Table[Year] + "ord" + Table[Order]
Hi Anonymous,
Please create a custom column with this formula:
"http:mywebsite.com"&Text.From([Year])&"ord"&Text.From([Order])
Hope it helps otherwise let us know.
Ninter
3 Replies
InterkoubessSolution Sage
Hi Anonymous,
Please create a custom column with this formula:
"http:mywebsite.com"&Text.From([Year])&"ord"&Text.From([Order])
Hope it helps otherwise let us know.
Ninter