Forum Discussion
What IF Parameter
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 'aver...
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
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