Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Circular Dependency using if DAX

Hi , 

 

I have created a column like below 

Current = IF('Final Table'[Type]="IMI",IF('Final Table'[BALANCE]<0,0,IF([DaysAged]<31,'Final Table'[BALANCE],0)),0) - No issues with this ,
But when i am creating another column like below 
31days = IF('Final Table'[IMI]="MI",IF('Final Table'[BALANCE]<0,0,IF([DaysAged]<31,0,if([DaysAged]<61,'Final Table'[BALANCE],0))),0) Its throwing Circular dependency error ..

I tried to change the way the logic is written , Like below 
31Days = if(Current=0,if([DaysAged]<61,'Final Table'[BALANCE],0),0)   Still the error shows up . 

Can you please help how to resolve this error. 
 
Thanks in Advance.
  • HotChilli's avatar
    HotChilli
    2 years ago

    Is [DaysAged] a measure?  If so, rewrite both columns so they do not use a measure

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    2 years ago

    Is [DaysAged] a measure?  If so, rewrite both columns so they do not use a measure

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Yes , DaysAged is a measure . so may be I can  write the logic as a column and replace in above logic .