Forum Discussion
Financial Forecasting
Hi jkulyk ,
Have you tried using the What-If parameter?
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
You can create a table with a range of values and then use them on a dax calculation on top of your actuals.
yes, i tried the what if parameters. But its not really working..
Do you mean to build a table like this?
Hi jkulyk,
The option is to create those what if parameters and the have a calculated measure to pick up the values.
Can you please give an example of what you want to achieve and the setup of your model. that will help to give you a more appropiate answer.
hi:) the problem is that i dont want to calc the what if parameters on top of my actuals. I have my actuals till today and then i want fixed values from the what if parameters:
As you see its not working because i cant link the parameters to a specific date range...
