Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

M - A cyclical reference was found during the evaluation.

Hi I'm creating a custom column in power query and it gives me the error "Expression.Error: A cyclic reference was found during the evaluation."

I have a date column that I've pulled the year from, [DescExtra] has hundreds of products, but I just want to conditional the values for these two products.

Table.AddColumn(
A_Extra_unidades,
"NuevaColumna",
each
if [DescExtra] = "DExtra" and [año] = 2022 then 1.1
else if [DescExtra] = "DExtra" and [año] = 2023 then 1.5
else if [DescExtra] = "MExtra" and [año] = 2022 then 1.2
else if [DescExtra] = "MExtra" and [año] = 2023 then 1.6
else 0
)

Any idea what's wrong?

3 Replies

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      2 years ago

      Hello.

      From what I understand, a conditioned column cannot be applied two conditions at the same time per line, only one, that's why I do it in custom:

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    I think that I created this column before the [año] column and because of this there is a cyclic