Scenario analysis with parameters

[msencie]

Hello Everyone,

I'm trying to create a dynamic business case in Power BI, where our potentials clients would have to input some data related to their business and with those, the business case of the solution we provide will adapt based on those parameters.

To do so, I created a table with the different phases of implementation filled with -1 or 1 depending if it is a cost or a revenue such as this:

Date	Phase 1	Phase 2	Phase 3	Phase 4	Phase 5	Phase 6	Phase 7	Phase 8
M1	-1
M2		-1
M3		-1
M4			-1
M5			-1
M6			-1
M7				-1	-1	1	1	1
M8				-1	-1	1	1	1
M9				-1	-1	1	1	1
M10				-1	-1	1	1	1
M11				-1	-1	1	1	1
M12				-1	-1	1	1	1
Total Y1	1	1	1	1	1	1	1	1
Total Y2			1	1	1	1	1	1
Total Y3			1	1	1	1	1	1

I tried to use the "What if" parameters to use as input from the clients, and then use these to apply calculations on my table above and then reflect the results in some charts, but I can't seem to link my parameters to the table, so I can't manage to make any calculations.

Does anyone have an idea on how I could do it?

Thank you very much in advance for your contribution.

Sincerely,

Mathieu

[v-sihou-msft]

@msencie

When create What-If Parameter, it will create a calculated and a calculated measure. You should use that measure in your calculation. 

I assume you have a flag measure (that  or 0 value) already. Then you just need to combine with the what-if parameter measure in your formula, like: 

=[Flag]*[what-if parameter measure]

For more details, please refer to links below: 

WHAT-IF ANALYSIS IN POWER BI DESKTOP

Create and use a What if parameter to visualize variables in Power BI Desktop

Regards,

[msencie]

@v-sihou-msft

Thank you for your answer.

Indeed what I did what to create a table with "Flag" values (-1, 0 or 1 depending if the column represents a cost or  a revenue), then I created the "what-if parameters" and then I used the "what-if parameters" value (so the measure) to create new columns in my flag table with calculations based on those "what-if parameters measures" but the calculations don't seem to apply.

Any idea?

Thank you very much!

[msencie]

@v-sihou-msft

I'm still facing some problems on this, basically, I can't seem to use the parameters in the calculations of a new column. When I do this:

New Column = Data[Column 1] * 30 . It works well but when I try to do this:

New Column= Data[Column 1] * 30 * 'What-if Parameter'[What-if Parameter Value] , it doesn't return anything.

Any on how to solve this?

Thanks in advance,

Mathieu

[Anonymous]

I am trying to do the same thing but have not been able to figure out how to use the chosen value of the what-if parameter in a new column.

In my case I have one what-if parameter for each category of product and need to be able to link the product name to the what-if parameter for my analysis.

Has anybody been able to figure out how to do this?

Thanks,

Caroline