Forum Discussion
Query Help - Create New Column with Value found in Row 1 of Column 2
Hi JSBDodson
I tried your second idea and found a workaround. You could refer to below steps.
1. Right click on the date cell and select Add as New Query.
2. Convert the new query Column2 to List rather than Table.
3. In original table, add a custom column = List.First(Column2). Then you will get the result.
What is strange is that if I extract the date from the original table directly by using "= SampleTable{0}[Column2]" and repeat the last two steps, I will get the same error "Expression.Error: A cyclic reference was encountered during evaluation." I guess if we extract the value from the same query or with reference to the query, it will display this cyclic reference error. However, if we extract the data from an independent query, this error will not appear.
Hope this helps.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
"Could this be caused because I am trying to insert this step into query editor before some previously made queries?" - Not sure.
To debug, I suggest removing all steps(copy the text somewhere into notepad so you don't lose it) except the initial source and the new column step. See if that works.