New Bug Encountered: “Expression appears to be part of a cycle” error from dereferenced value

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:

[Parent].[Ancestors]

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.

0 6 359
6 REPLIES 6
Top Labels in this Space