Forum Discussion

2_Flash's avatar
2_Flash
Regular Visitor
2 years ago
Solved

NPV with dynamic value selection

Hi,   I'm trying to develop an investment review model where users can easily select initial investment values, tax rates, and other parameters to dynamically calculate the NPV. I've ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago
    but I need to go into Powerquery each time I need to change a value.

    No, you can do that directly in Power BI, via "Edit Parameters"

     

     

2_Flash's avatar
2_Flash
Regular Visitor
2 years ago

Thanks for your repsonse:

1) Re: Power BI does not support manual entry by default (some third party visuals do). - Prefer to stick to standard PowerBI

2) Re:Change the Power Query Parameter to "Enable Load"  and it changes from an expression to a partition and will be accessible in Power BI. - Yep, did that, but I need to go into Powerquery each time I need to change a value.  Probably not feasible for a group of users.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    but I need to go into Powerquery each time I need to change a value.

    No, you can do that directly in Power BI, via "Edit Parameters"

     

     

    • 2_Flash's avatar
      2_Flash
      Regular Visitor
      2 years ago

      Gotcha! Ok, I'll play around with this concept. Thank you