Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate prognosed total / circular dependency issue

Hi all,   For a liquidity prognosis I want to make a measure that calculates the month's total liquid position based on previous months' expenses and prognosed liquid position. My table has 4 rows...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi,

     

    I managed to solve the problem by simply creating 12 measures (one for each month) that each take the total value of the month before.

    I think my desired outcome is impossible in Power BI, as it will always lead to circularity.

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous ,

Prognosis is using Cash position and Expenses  then they are not

 

and if Prognosis  using Cash position then what is the need to use it again.

 

Can you share actual formula