Forum Discussion
Solved
Cannot spot Syntax failure/list min query
Hello, I made a calculated column for this table: 11.05.2021 Tuesday 1 1234 12.05.2021 Wednesday 1 1235 13.05.2021 Thursday 1 1236 14.05.2021 Friday 1 1237 15.05.2021 Sa...
This is a bit of a guess. Replace
Ordertablein the formula with the previous step name like ...... #"whatever"
A cyclic reference is when A refers to B which refers to A and so on or even A refers to A (refers to A ...)
In Power Query a table is a sequence of query steps so in this case the last query step referred to the table name (which included the last query step) so it was cyclic.
The general advice is that each query step should act on the previous step. That's not always true but it's a reasonable starting point.
Got it. Thanks for the explanation HotChilli
