Forum Discussion
Flexing Calculated Column Values for Forecasting / Predictions
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 , you can try us what if parameter?
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
2 Replies
PBI_Inquisitor , you can try us what if parameter?
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
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.
