Forum Discussion
Solved
Scenario modelling tool
Hello Trying to do something that would be very easy in excel (maybe in power bi too). I want to have a field where the user can select the discount %. I then want to use that discount figure to ...
create a numeric range .you can set the min , max and the increment. ( 1, or 0.1 ..etc.. )
this will create a table ( in the image above called Paramter ) with one field.
then create a measure =
selectedvalue( Paramter[field_name]) , 1 )
then in your measure that calculates the sales price, you can multiply by the above measure,
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
selectedvalue( Paramter[field_name]) , 1 )
what should be entered in field name? this has not been defined in the process??