Simulation changing parameters for each row

[CrgJnr]

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!

[vanessafvg]

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.

[CrgJnr]

I've changed my question with a sample of data...

Thank u!

[vanessafvg]

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

[CrgJnr]

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.