Forum Discussion

Gabriel_Pedri's avatar
Gabriel_Pedri
Resolver I
2 years ago
Solved

Power BI Recursion - DAX

I need to calculate the Final Cash Balance using recursion. Basically, we have 2 accounts to calculate where one depends on the other to exist:

-> Initial Cash Balance = Final Cash Balance of the previous day
-> Final Cash Balance = Operating + Financing + Investments + Exchange Variation + Initial Cash Balance

 

 

Is there any way to calculate both codes using recursion in DAX?