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
Community Champion
2 years agofrom 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.