Circular Dependency

[Anonymous]

Hi everyone,

I have an issue with calculated columns. I need a column FinalBalance that will contain final balance for each account_id on curr_date.

I tried to use a second column InitialBalance:

FinalBalance = IF(Table[curr_date] = MIN(Table[curr_date]); Table[input_sum] - Table[output_Sum]; Table[InitialBalance] + Table[input_sum] - Table[output_Sum])

InitialBalance = IF(Table[curr_date] = MIN(Table[curr_date]); 0 ; CALCULATE(SUM(Table[FinalBalance]); Table[curr_date] - 1))

but as expected it resulted in a circular dependency error.

I'd appreciate it if you help me to solve this issue.

My dataset:

[BalaVenuGopal]

Hi @Anonymous ,

Could you please explain what are you expecting from this result set your calculated columns have dependency on each other first you create one calc column then use that for second reference.

Plese explain your psudo logic then i can give  you calc column formula.

Thanks