Flexing Calculated Column Values for Forecasting / Predictions

[PBI_Inquisitor]

Hi

I have a [Sales] table which shows how many [Days] have been [used] to date and how many are [remaining]

I can get a [Run Rate] column by dividing Sales/Used

I can get a [Forecast] column by [RunRate] * [Remaining]

What I want to be able to do is allow the end user to FLEX the [RunRate] to see how different scenarios might pan out.

If this could be saved great but not essential

Is this possible

[PBI_Inquisitor]

thank you @amitchandak I was just about to update my post as have spent the afternoon playing with What If Parameters - i was able to create and then add to the page as a Slicer which I could then create a column to multiply by this slicer (flexed) value!

Appreciate you answering my question.

[amitchandak · Accepted solution]

@PBI_Inquisitor , you can try us what if parameter?

https://docs.microsoft.com/en-us/power-bi/desktop-what-if