Add Year-end projection (production) to Stacked Column chart

[jsarnold]

I would like to add a simple projection of production through years end to the bottom Stacked Column Chart:

I want to take production YTD through Q3 and multiply by (12 / 9) and have the difference displayed as Q4 data in the lower chart.

I'm not sure of the best way to accopmlish this, and any help is greatly appreciated! 

Thank you!! 

[Eric_Zhang]

@jsarnold

Your question is not clear for me. Could you post any sample data? Even better you can upload the pbix file to OneDrive or any web drive and share the download link. Do note to mask sensitive data before uploading.

[jsarnold]

My files uses several data sources, including an on-premise SQL server, so it may be easier to explain with screenshots.

I have got very close to what I was trying to accomplish. I created a new table that summarizes Production data in a table:

Resulting Table:

 

Now I want to replace the 4th Quarter value with (Q1 + Q2 + Q3) / 9*12, so I need a DAX formula to replace the '0' with in this function:

I'm not sure how to add the 1st through 3rd quarters up.

Any help is greatly appreciated! 

Thanks again! 

[jsarnold · Accepted solution]

My lack of DAX knowledge was the only problem!

 

I apologize for the clutter, and I appreciate the support!