Forum Discussion
S Curve Dvelopment - Forecast Line
Community SupportHi Anonymous ,
I am not sure what desired result would you want, could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
For example: could you please make a description for the number below?
Best Regards,
Amy
Hello v-xicai
The matching line is what i am trying to get.
I have 3 values - Baseline value, actual value and forecast value
In the example the actual values run until 12th May. The forecast values start on 6th May.
As per the measure the forecast is a cumulative forecast line + actual to date so that they meet. The curve is correct but unfortunately as there are dates where the 2 overlap (6-12th May) it is forcing a misalignment between the 2 lines.
The 13659 is the delta between the 2. If i subtract that as a constant value (number) it fixes the alignment issue with the line however, when i use a formula to rectify as per the middle example it only rectifies it for the current week. I need to do that calculation in such a way that it then subtracts for every possible date that the forecast line runs for