Solved: Concat Text + Colum power query

Anonymous · ‎11-17-2017

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]

Interkoubess · ‎11-17-2017

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 · ‎11-17-2017

Details

Year and Ord is a Number

ty

Interkoubess · ‎11-17-2017

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 · ‎11-17-2017

in Power Query or Dax?

Ty

Concat Text + Colum power query