rolling forward equation

[chrismiller]

I am trying to create a dax querie that solves my issue... so the table below shes how the equation works..

starting with the most recent 'actuals' data (may2017) -A we add next month forcast - B which equals C of the new column and that continues onward

This photo shows what I have, I have the actuals and I have the forecast I just need to create this new column. I figured it would have to begin with the baseline (ie specify starting at max/recent spent surrent month/actuals) then use the previously calculated 'C' and use that as the new 'A'

sorry if my description is confusing. any help is appreciated

[technolog]

Can you please tell me if the problem is still relevant? If you managed to solve it in some way, please write here how you solved this problem. Then it will be possible to mark this problem as solved.

If not, it may make sense to ask the question again, thus confirming the relevance of this problem.