Mixing Actual months sales to forecast sales to give projected year end sales

Power BI
1

I have 3mths Actual Data (Qty & Revenue) plus forecast quantity for each off the next 9 months and I want a Forecast Sales for the Year-End.
So Forecast Sales = 3 mths Actual + 9mths Fcast Qty * Average selling price of the first three months.
Being a beginner at PBI not sure how to structure it…any ideas

2

Welcome @Alexcel on forum. Here is a link of a similar post that might guide you

Actuals and Forecast

Also if you can watch Sam’s videos on Budgeting and Forecasting.
Forecasting Logic in Power BI using Dax

Hope it will be of help to you.

Thanks and have a good day

Najah

3

Thanks for posting your question @Alexcel. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.