Use a specific cell (text)

[Ad_456]

How do I reference a specific cell value in query editor - add custom column. 
I want to use the value of column 1 first row in a new column. How can I do that

[Vijay_A_Verma]

If it is in the same row, you just need to reference that column like

=[Column1]

If you want to reference some other row, then various methods are there. 

But since you want to refer to only Column1 in first row, you can do like this

=Table.First(#"Your previous step")[Column1]

OR

#"Your previous step"[Column1]{0}

OR

#"Your previous step"{0}[Column1]

[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.

[Ad_456]

Sorry, I don't get it! What do you mean by "your previous step"? 

[Vijay_A_Verma · Accepted solution]

In PQ, every statement refers to previous statement if it has to refer to a table. In general, it is always the immediate previous statement.

Hence see the below code

Source = abcde,

#"Added Custom" = gjlkd,

Result = #"Added Custom"{0}[Column1]

// See how Result refers to previous step