Forum Discussion

chrismiller's avatar
chrismiller
Helper I
9 years ago

rolling forward equation

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

 

 

DAX

1 Reply

  • technolog's avatar
    technolog
    Super User
    2 years ago

    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.