Forum Discussion
CrgJnr
2 years agoFrequent Visitor
Simulation changing parameters for each row
I would need to create a dashboard with manual entries to do simulations, moving away from managing this situation in Excel. Specifically, the objective is to have an overall cost value and an o...
vanessafvg
2 years agoCommunity Champion
from what you saying what if funtionality in power bi is for this specific purpose, however go through the material to see if thats what you need
a video to get you going https://www.youtube.com/watch?v=28PDdA3SROU
some power bi documentation around it https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
essentially though the actual functionality is held in the numeric range parameter, and you can create those to adjust your data with your simulations
- CrgJnr2 years agoFrequent Visitor
What if doesn't allow u to work individually for each resource. I need to select, for each resource, the months of engagement and the percentage.