Circular reference

[Anonymous]

Hello,

I'm facing an issue which is quite easy to solve in xls but for which I do not manage to find a solution in Dax.

Basically I need to calculate a forecast price based on 3 periods before multiply by a % of evolution.

In the picture below, the information in black is the one that I have and the information in green is the one I'm looking for a solution.

Basically I can manage it until April, based on the last figure known (january).

But in May we need February, which is a calculate figure, and here is when the problem begins.

If someone have any idea it would be great.

Regards

Martial