Help with circular dependency

[hdavidson]

I have a months column in my table (TableA) with values as below :

Month No Column1 Column2
----------   ---------- ----------
1
2
3
4
5
6
7
8
.
.
.
.
.
.
.
.
240

Now, I am trying to create two columns using DAX as below :

value at Duration1 = if(Month No < 70, TableA[column2],TableA[column1])

value at Duration2 = if(Month No < 140, TableA[column2],TableA[column1])

First one gets created fine, however I get a circular dependency error
while saving the second one.

I need to have 2 different columns.

Any help would be much appreciated.

[Sumanth_23]

hi @hdavidson - Have any either of the columns Duration 1 or Duration 2 been derived from Month No? If that is the case then there is chance that you may get a reference error. Can you share the sample pbix file for reference? 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks! 

[hdavidson]

tried uploading the screenshot of the error & the 2 columns that I have created but no luck got an error there as well, so typed out the column DAXs. 

hope this helps!

Value at Duration2 = if(FinalTable[Duration] < 145, FinalTable[Value], FinalTable[BOM Interest Curve])

This is whereI am getting the error as "A circular dependency was detected: FinalTable[Value at Duration1], FinalTable[Value at Duration2], FinalTable[Value at Duration1]

pasted below is the first column which is good :

Value at Duration1 = if(FinalTable[Duration] < 73, FinalTable[Value], FinalTable[BOM Interest Curve])

[amitchandak]

@hdavidson , They should work. Can you share sample pbix after removing sensitive data.

these seems fine

value at Duration1 = if([Month No] < 70, TableA[column2],TableA[column1])

value at Duration2 = if([Month No] < 140, TableA[column2],TableA[column1])

[hdavidson]

@amitchandak tried uploading the screenshot of the error & the 2 columns that I have created but no luck got an error there as well, so typed out the column DAXs. 

hope this helps!

Value at Duration2 = if(FinalTable[Duration] < 145, FinalTable[Value], FinalTable[BOM Interest Curve])

This is whereI am getting the error as "A circular dependency was detected: FinalTable[Value at Duration1], FinalTable[Value at Duration2], FinalTable[Value at Duration1]

pasted below is the first column which is good :

Value at Duration1 = if(FinalTable[Duration] < 73, FinalTable[Value], FinalTable[BOM Interest Curve])

[V-lianl-msft]

Hi @hdavidson ,

Still unable to clearly understand your scenario, try pasting the table data or share the sample pbix via cloud service like onedrive for business.

Please mask any sensitive data before uploading

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.