Forum Discussion

georgy's avatar
georgy
Frequent Visitor
6 years ago

circular reference error

Hi All, I have problem where I need to use prior period closing balance as current period opening balance. Something like table below. The problem is that ADDITION column is % of opening balance and...
Need Help
MFelix's avatar
MFelix
Super User
6 years ago

Hi georgy ,

 

Can you share some more information about the addition column especcially on how it returns the value based on the Opening Balance?

 

If the addition values was a column value you just needed to create the following two measures:

 

Opening Balance =
1
    + CALCULATE (
        SUM ( 'Addition Table'[Addition] );
        FILTER (
            ALL ( 'Addition Table'[Period] );
            'Addition Table'[Period] < MIN ( 'Addition Table'[Period] )
        )
    )

Closing period = [Opening Balance] + SUM('Addition Table'[Addition])

 

However this will only work if your column addition is based values you just need to define the opening balance for the first period. Being different calculation based on the percentages and other thins this need to be adjusted.

 

Check PBIX file attach.

 

Regards,

MFelix

  • georgy's avatar
    georgy
    Frequent Visitor
    6 years ago

    Hi MFelix,

    Thank you for a quick reply.

    As mentioned additions are % of opening balance, there are losses % as well and other absolute values that change from month to month. Something like table below.

    Cheers,