Circular Dependency - 2 columns referencing each other

Hi marinahani ,

You're encountering a circular dependency issue because TotalCurrentMonth depends on FromPreviousMonth, and FromPreviousMonth depends on TotalCurrentMonth. To resolve this, you need to break the dependency by using variables or iterators.

Try this approach:

DAX

VAR PrevMonthValue =
CALCULATE(
MAX('MRR Level 2'[TotalCurrentMonth]),
DATEADD('MRR Level 2'[FirstofMonthMRRDate], -1, MONTH)
)

RETURN
SUMX(
'MRR Level 2',
PrevMonthValue +
'MRR Level 2'[New Logo] +
'MRR Level 2'[Cross Sell] +
'MRR Level 2'[True Up] +
'MRR Level 2'[Price Increase] +
'MRR Level 2'[True Down] +
'MRR Level 2'[Price Decrease] +
'MRR Level 2'[Churn]
)

• The PrevMonthValue variable fetches the previous month's TotalCurrentMonth without creating a direct dependency.
• The calculation then adds up the values without referencing FromPreviousMonth in a way that causes a loop.

If you still face issues, consider storing FromPreviousMonth in a separate calculated table and referencing it instead.

Please mark this post as solution if it helps you. Appreciate Kudos.