What IF Parameter

[Anonymous]

Forecasted Days till completion = Backlog / average completed per day

average completed per day = total completed/ number of days on project 

I created a what if parameter that changes the 'average completed per day' to adjust the forecasted days till completion

(so I have a slider where i can change the average completed per day to more of less and it will show me the forecasted days till completion based off of the number i chose on the slider) 

However, I don't know how to create a what if parameter where i can change the Forecasted Days till completion to show me how many i need to average completed per day to get the Selected Forecasted Days till completion 

(So if i change the Forecasted number of days till completion to 5, i want it to reflect how many i have to average completed per day to get that number) 

Formula for slider to adjust the average completed per day 

Backlog / [Team average completed per Day Parameter]    

Thank you in advance to any help! 

[Anonymous]

Hi @Anonymous,

Now that you have created what-if parameter for Forecasted Days till completion, you eventually want to get the corresponding value of average completed per day reflected by this parameter? Could you please provide some sample data(exclude sensitive data) in order to clearly understand your needs? Thank you.

In addition, hope the following documentations can help you.

https://docs.microsoft.com/en-us/power-bi/desktop-what-if#creating-a-what-if-parameter

https://databear.com/power-bi-what-if-parameters/

Best Regards

Rena

[Aron_Moore · Accepted solution]

Couldn't you just create another 'What If' for Forecasted Days and put it in a measure like

Average Completed per Day = Backlog / Forecasted Days