Calculator for activities based on hours budget

[maxanatsko]

Hi there.

Is it possible to make a calculator like this (follows) in pBI?

Lets say we have a budget - 20 000 hours.

We have 3 activities: test creation, test run, retest:

• 1 test = 3 hrs
• 1 test run = 1 hr
• 1 retes = 0,5 hr

What i wanna do is to see how many of those activities and in which proportion could be included in a budget (20k hrs).

Like:

3000/2000/1000

4000/1000/100

etc

And to able to choose that i need, for example, 3456 test, and to see how many test runs or retests i need to do. If i say choose numbers for 2 activities out of 3, it will tell me remainder for 3rd.

[v-yuezhe-msft]

Hi @maxanatsko,

I am not quite clear about your requirement, could you please post raw data of tables and post expected result in table?

Thanks,
Lydia Zhang