Forum Discussion
Circular Dependency with LOOKUPVALUE
See if this video from the gurus at SQLBI helps:
Hi PaulDBrown. The video was very clear and I was able to understand why it was happening. That calculated column and the lookupvalue had all the columns from the table BALANCETES depending on it, which means when calculating CVEE-FC it was including the CSEP column.
All i had to do was adding CALCULATE and ALLEXPECT to reduce the columns to what i wanted.
Printscreen:
Thank you so much, this was bothering me for a long time.
Gonqq Is Regras[CVEE- FC] a calculated column?
Hi Greg_Deckler . Regras[CVEE- FC] is a column from the Table Regras which i import from excel.
Screenshot of a part of table Regras:
See if this video from the gurus at SQLBI helps:
Hi PaulDBrown. The video was very clear and I was able to understand why it was happening. That calculated column and the lookupvalue had all the columns from the table BALANCETES depending on it, which means when calculating CVEE-FC it was including the CSEP column.
All i had to do was adding CALCULATE and ALLEXPECT to reduce the columns to what i wanted.
Printscreen:
Thank you so much, this was bothering me for a long time.