Concat Text + Colum power query

[Anonymous]

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]

[Anonymous]

Details

Year and Ord is a Number 

ty

[Interkoubess · Accepted solution]

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

[Anonymous]

in Power Query or Dax?

Ty