Forum Discussion
Agile Burnup Chart
Thank you Yingjie Li
Do you have any advice on re-creating a forecast line in DAX? Perhaps using some kind of moving average from the past to forecast into the future or other algorithm? I was thinking I could then have a binary switch where up to the line of real data it mirrors that and then it forecasts based on the historical data into the future with a dotted line. I can overlay the historical data line and stop it and the forecast line so it looks like they are one line to the user. The data is based on cumulatively when work is complete so there's no seasonal or other trends it is just an increasing velocity of work with a number of teams building up & sustaining momentum of development activity to close down scope work. Thank you
Community SupportHi Anonymous ,
If only have cumulative data without any confidence level or seasonal point, it could be difficult to create forecast value.
Perhaps you can define the forecast regulation and refer this issue to try to get the forecast value and create a chart to show it:
https://community.powerbi.com/t5/Desktop/Confidence-Level-95/td-p/275280
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.