Forum Discussion

marinahani's avatar
marinahani
New Member
1 year ago
Solved

Circular Dependency - 2 columns referencing each other

Hi - would appreciate some help on this.   This is what I have right now. But the correct calculation for TotalCurrentMonth should also include value from FromPreviousMonth. Which then causes the c...
Need Help
  • marinahani's avatar
    marinahani
    1 year ago

    I took your suggestion and did some tweaks and it worked. Managed to get the result exactly as needed

     

    CALCULATE(
        SUMX(
            'MRR Level 2',
            '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]
        ) ,
        FILTER(
            ALL('MRR Level 2'[FirstofMonthMRRDate]),
            'MRR Level 2'[FirstofMonthMRRDate] <= MAX('MRR Level 2'[FirstofMonthMRRDate])
        )
v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
1 year ago

Hi marinahani 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

marinahani's avatar
marinahani
New Member
1 year ago

Thanks and done.