Forum Discussion
Circular Dependency with LOOKUPVALUE
Hi , i'm currently using lookupvalue on some calculated columns and i can't seem to understand as to why the circular dependency is happening. Screenshots:
Any help would be highly appreciated.
Thank you
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.
4 Replies
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:
