I have a table, Table, with key, [Key], and a ref column, [Parent]. [Parent] references rows in Table 1.
I have a virtual column in Table, [Ancestors]. It throws an “Expression appears to be part of a cycle” error when using this formula:
Even if [Ref 1] =/= [Key 1].
I tried this and it got the same error:
IF( OR( [Parent]=[Key], ISBLANK([Parent]) ), LIST(), [Parent].[Ancestors] )
It seems like I should be able to access a value from the same virtual column, but a different row without a circular reference.