Forum Discussion
Solved
Use a specific cell (text)
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
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
Sorry, I don't get it! What do you mean by "your previous step"?
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