Forum Discussion

Borjaveigasvh's avatar
Borjaveigasvh
Regular Visitor
6 years ago
Solved

Problema con referencia circular

Buenos días,    estoy creando dos columnas calculadas en una tabla y siempre que hago la segunda me dice que tiene referencia circular cuando no veo la relacion entre ellas. Me podeis echar uan man...
  • Borjaveigasvh's avatar
    Borjaveigasvh
    6 years ago

    Thanks for sharing, I found the problem, it was in how my tables had the relation created. 

     

    I had selected both in one of the tables that needed to be single, and was creating the circular problem.

     

    Best

    Borja 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Create these columns in Power Query instead.

  • Borjaveigasvh's avatar
    Borjaveigasvh
    Regular Visitor
    6 years ago

    l'll try to do so. thanks for the tip. 

  • Borjaveigasvh's avatar
    Borjaveigasvh
    Regular Visitor
    6 years ago

    But do you know howcome those two calculated columns create a circular reference? their calculation is not dependent on the previous column so I do not understand the reason.

     

    Thanks for sharing knowledge

     

    Regards

    Borja 

     

     

  • Borjaveigasvh's avatar
    Borjaveigasvh
    Regular Visitor
    6 years ago

    Thanks for sharing, I found the problem, it was in how my tables had the relation created. 

     

    I had selected both in one of the tables that needed to be single, and was creating the circular problem.

     

    Best

    Borja