Circular dependency Error

[LuciaS]

Hi, I have problem with Circular dependency Error. I have columns that are dependent on each other.

This is how it sholud work with with imaginary values in column Hepl 

But when I want to use values which are dependent on other column there is Circular dependency Error

Help = in first year and month of data= 1000000 until 12. month then value from "Column" until next 12. month 

Release= previous value from Help * Pattern

Column = previous value from Help - Release 

Is tehere some way how to fix it ? 

Thanx 

[LuciaS]

@BeaBF There is still Circular dependency Error 😞 

When i will do it with measures instead of columns in BI there will be still Circular dependency Error ?

[BeaBF]

@LuciaS Hi!

Circular dependency errors occur when a formula in a table column depends on the result of another column, and that other column depends on the result of the first column. In your case, it seems that there is a circular dependency between the "Help_values", "Release", and "Column" columns. One possible solution to this problem is to break the circular dependency by introducing a new column that calculates the "Release" value based on the previous value of the "Help_values" column and the "Pattern" column, and then using this new column to calculate the "Column" column.

1. Create a new column called "Release_temp" with the following formula:

Release_temp = [Help_values] * [Pattern]

2. Modify the "Help_values" formula to use the previous value of "Column" instead of the current value of "Release":

Help_values = IF(ISBLANK([Column_prev]), 100, [Column_prev] + [Release_temp])

3. Create the "Release" column with the following formula:

Release = [Release_temp]

4. Create the "Column" column with the following formula:

Column = [Help_values] - [Release]

BBF