Dynamic Forecast formula in Excel (Power Query/Power Pivot/DAX)

[LIONEL CHARLEY]

[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD]Items
[/TD]
[TD]Date
[/TD]
[TD]Actual
[/TD]
[TD]Forecast
[/TD]
[/TR]
[TR]
[TD]# of Work Order
[/TD]
[TD]Jan
[/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]# Of Work Order
[/TD]
[TD]Feb
[/TD]
[TD]7
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]#of Work Order
[/TD]
[TD]Mar
[/TD]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]# of Work Order
[/TD]
[TD]Apr
[/TD]
[TD]0
[/TD]
[TD]?
[/TD]
[/TR]
[TR]
[TD]# Of Work Order
[/TD]
[TD]May
[/TD]
[TD]0
[/TD]
[TD]?
[/TD]
[/TR]
[TR]
[TD]# of Work Order
[/TD]
[TD]Jun
[/TD]
[TD]0
[/TD]
[TD]?
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]













I have above table coming out from power query after unpivot and I would like to develop formula to forecast dynamically, As you can see in the above, we have # of Work Order from Jan to Mar and would like to know what is the forecast for April to Jun. Similarly after the next month we will have 4 month of actual and would like to predict for last two months. Is there any formula we can use.

My goal is plot actual and forecast through a line chart