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

Hello marinahani 

Thanks for reaching out to the Microsoft Fabric Community Forum


We just wanted to confirm that the solution provided by danextian  is accurate and should help resolve the issue you're facing.Could you please confirm if your query have been resolved or not?If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently. If you continue to face issues, feel free to reach out to us for further assistance!

Thank you!