PowerQuery Expression.Error: A cyclic reference was encountered during evaluation

Question

Can't find the error in formula - the value is calculated throughout the column (when keeping errors - no rows shown), but I can't apply the changes though.((

if [Index] > 0 then 
if articles_pivot{[Index]-1}[IN] <> null (when omitted the error remains) and [IN]=null then
articles_pivot{[Index]-1}[IN]
else null
else null

Thank you for advice!

Answer 1

If I an reading it right, all you really need to do is right click IN column and do fill ... down...

Otherwise, see if this works

= try if articles_pivot{[Index]-1}[IN] <> null and articles_pivot{[Index]}[IN] = null then articles_pivot{[Index]-1}[IN] else null otherwise null 

Answer 2

decided to make it another way - in the origin table I've added Index column starting 0 and in the pivot table (made by pivoting the origin one) I've added index column starting 1, then merged them..)