Forum Discussion
Data entry fields
Hi DanCasSan,
You should use a Whatifanalys that allows you to have a parameter for user input, be aware that this is a table with the values you define so it can be from 1 to 100 having values from 5 to 5 (20 rows) or another setting like 0 to 1 with increments of 0.01 this will give you 100 rows.
Then just use the measure created automatically to get the calculation for example look at the PBIX file attach and the documentation on what if analysis.
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
In my example I made a table from 0 to 5 with increase of 0.5 so you can go above the price or below the price. you can also set negative values on the parameter.
Hi DanCasSan,
You should use a Whatifanalys that allows you to have a parameter for user input, be aware that this is a table with the values you define so it can be from 1 to 100 having values from 5 to 5 (20 rows) or another setting like 0 to 1 with increments of 0.01 this will give you 100 rows.
Then just use the measure created automatically to get the calculation for example look at the PBIX file attach and the documentation on what if analysis.
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
In my example I made a table from 0 to 5 with increase of 0.5 so you can go above the price or below the price. you can also set negative values on the parameter.