Forum Discussion

Sammy22's avatar
Sammy22
Helper I
2 years ago
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 ...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    Sammy22 

     

     

    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! 🤠