Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Forecast method

Hi everyone, i am struggling to calculate a forecast and i was hoping someone here could help me. I Have the dates for the entire month, the plan (S&OP) for the month (daily) and the accumulated pla...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Based on what I  got

    One of the method

     

    Assume Actual is a measure

     

    [Actual] + calculate(Sum(Table[S&OP]), filter(all(Table), Table[Date]<= Max(table[Date]) ) )

     

    or actual last non blank

     

    lastnonblankvalues(Table[Date], [Actual])  + calculate(Sum(Table[S&OP]), filter(all(Table), Table[Date]<= Max(table[Date]) ) )

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Based on what I  got

One of the method

 

Assume Actual is a measure

 

[Actual] + calculate(Sum(Table[S&OP]), filter(all(Table), Table[Date]<= Max(table[Date]) ) )

 

or actual last non blank

 

lastnonblankvalues(Table[Date], [Actual])  + calculate(Sum(Table[S&OP]), filter(all(Table), Table[Date]<= Max(table[Date]) ) )

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.