Recursive Calculation in DAX

[lbaysinger20]

I am currently trying to perform a price forecast calculation in DAX in excel. I have quarterly price data and a base price. I need to take the base price and add the price difference of the previous two quarters to the base price to find a new calculated price. This needs to be repeated using the new calculated price as the base price and carry on for future pricing. An image of the Excel logic is included, for example. DAX code to avoid self-referencing would help a lot. Calculated columns are ok, as I believe that is the only way to reach the goal at this point. Thank you!

[Deku]

You can have a look at the Dax financial functions. Not used them myself but there might be something there

[lbendlin]

You cannot do conditional aggregations in DAX. Your only option is List.Accumulate in Power Query.