Forum Discussion
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 overall revenue value by selecting resources within a team (from a Excel Table Source: ID, cost, revenue) but with the possibility of varying the months of engagement and percentage for each month/resource.
I have available:
- list of resources and the daily costs and revenues (fixed)
| resource_code | cost_daily | revenue_daily |
| a1 | 25 | 72 |
| a2 | 22 | 47 |
| ... | ... | ... |
- working days for each month.
| month | working_days |
| 01/01/2024 | 22 |
| 01/02/2024 | 23 |
| 01/03/2024 | 21 |
| ... | ... |
I need to enter (or choose from something), for each resource, the months of engagement (e.g. January, February, March) and the percentage of engagement for each month (not employed every day, but a percentage, example: I need to use resource A January at 50% and February at 75%). To obtain:
| team | working_days_formula | working_days_result | cost | revenues | TOTAL_cost | TOTAL_revenue |
| a1 | (22Jan *0.50)+(23Feb*0.75) | 28.25 | 25 | 72 | 706.25 | 2034 |
| a2 | (22Jan *0.30)+(23Feb*0.25) | 12.35 | 22 | 47 | 271.7 | 580.45 |
| ... | ... | ... | ... | ... | ||
| TOTAL | 977.95 | 2614.45 |
Once these values have been entered I would like to have my 2 estimates and then, possibly, modify again the parameters to find optimal value.
Do you think it is feasible in PowerBI? Is there any kind soul who could show me how?
Thank you!
4 Replies
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
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.
it is only in doing you would figure that out, in order for me to absolutely know, the devil is the in details, which i dont have enough to answer, as well as understanding the input vs that output, the data model, there are many nuances in data, so you would need to provide sample data that that has all your scenarios. without that i dont have enough information to tell you absolutely this will work.
in theory you should be able to write code or use filters to direct your what if scenarios.
try one and see if it meets all your requirements.
I've changed my question with a sample of data...
Thank u!
