How to calculate Actual sales YTD and Forecast for rest of rear in powerpivot

[panther0816]

I have several files that I have compiled into power pivot and I am trying to create a formula to give me a Full Year Forecast field that I can use in my pivot table. The Full Year forecast would equal the sum of Actuals for the current calendar date minus 1 month plus the sum of Forecast for the current calendar month and each subsequent month through the remainder of the year.

[JeteMc]

Hello panther0816 and Welcome to Excel Forum.
I don't understand what you want. Looking at the pivot table it seems that the SBU named INT already shows the actuals for the months up until April and the forecasts for the remainder of the months. Could you tell or show us what you would like that is different from what we already see?
Let us know if you have any questions.