Create a new column with content of a specific cell reference

[DTV]

I have a text in a column named Column1 at row 4, which I need to apply against each row of data as a new column.

I have tried as follows: = Table.AddColumn(#"PreviousStep", "NewColumn", each [Column1]{3}) 

I don't get any syntax error and the new column gets created, but every line in this new column just shows "Error"

Can you help solve this issue.

[slorin · Accepted solution]

Hi,

= Table.AddColumn(#"PreviousStep", "NewColumn", each #"PreviousStep"[Column1]{3})

 Stéphane