Forum Discussion
Scenario modelling tool
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??
the field name is the name of the column name created when creating the range .
like in my exmple,
the name is Paramter, so : selectedvalue(paramter[Paramter])