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...
  • 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.