Calculation of a result based on several factors

[Anonymous]

Hello Everyone,

I would like to know if this is possible on power Bi?

I would like to know the minimum value of column Z in function column A = N * Fixed Data  - with N variable.
Knowing that column B (calculated from column A) not exceed 52.
Knowing that column C (calculated from column A)must be less than column E
Knowing that column D (calculated from column A) If columnF= 'Text', shall not exceed 1

I thought I could create another table of values (as below) of N that respects these conditions, then get the minimum value of column Z

(Here Fixed data = 200 & E = 45%)

N	A	Z	B	C	D
1	200	1 155,83 €	24	4%	1
2	400	642,43 €	12	9%	1
3	600	485,12 €	8	13%	1
4	800	416,82 €	6	17%	1
5	1 000	393,03 €	5	22%	1
6	1 200	369,24 €	4	26%	1
7	1 400	389,96 €	4	30%	1
8	1 600	366,17 €	3	35%	1
9	1 800	386,89 €	3	39%	1
10	2 000	407,61 €	3	43%	1

Do you think this is feasible? And how? 

Thanks in advance, 

Regards,

[Cmcmahan]

This sounds like the perfect case for setting up a What-If parameter.

If you set up Fixed data and E as What-If Parameters, you should be able to calculate the rest, no problem. Getting the minimum value of Z would likely require you to use ADDCOLUMNS to create the virtual table, and calculating the MIN of that.

[Anonymous]

This isn't really what I'm looking for. Agree with the ADDCOLUMNS. 

I'm looking to build this virtual table using an existing table. My unknown value is N. The fact is to build this virtual table until the conditions are down. And after calculating the min of Z

[Cmcmahan]

This seems like an interesting problem, but I have no idea what you mean by "The fact is to build this virtual table until the conditions are down."

It seems like you're trying to solve some sort of debt payment optimization problem.  I see how to calculate A, but can you share with us how you would calculate B, C, and Z starting with the values A, E, and N? 

It seems like there's another variable (I'm guessing the principal of 4800, and whatever the interest rate is) that you've used in these calculations.  If you can share all the parts of the calculations, we could give better advice on how to set up the measure.