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...
  • HotChilli's avatar
    HotChilli
    2 years ago

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

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity 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 .