Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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]
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.