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"

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
the challenge is that the values—such as investment amounts and tax rates—must be entered manually.

Power BI does not support manual entry by default (some third party visuals do).  The standard functionality is limited to "What-if?" parameters with a range of max 1000 discrete values

 

I'd prefer to use parameters, but they're not working with the table format.

They will if you let them.  Change the Power Query Parameter to "Enable Load"  and it changes from an expression to a partition and will be accessible in Power BI.  You can also modify Power Query parameter values from the Power BI menu, but then you will need to manually initiate a refresh for the change to take hold.  Not something your report users can do.