Forum Discussion
Use a specific cell (text)
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
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]
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