Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Calculate Value required to meet a Target in weeks remaining ?

I have a little query that maybe someone can support with...


I have a target value to meet by the End of Sept or Week 39...


I have a rolling value for the year to date as of week 30 , which will change.


What I am looking to do is calulate what value per week I need to run at in order to meet the target at week 39?


Example say the target is 83% at Week 39 and we are 81% now then what do I need to run at to get to 83%  So the answer should be something like 83.8% per week(I know that is not accurate)





Super User
Super User

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors