Calculated Column based on Condition.

[Anonymous]

Hi All,

I have a situation where I've to add a calculated column to my report and I'm not sure how to move forwartd with it.

Situation: My CTO wants to have another column i.e "Proposed ARR" and wants a dynamic text box on top like if he inputs 10% there the value in the column "Proposed ARR" should show 10% increase of the ARR value in the column ARR

Existing Report:

I want something like below: 

Here column J is simply F2*1.1

Just want to ask is this possible in Power BI? where we can give a text box and user can input a value and then the value changes as per the input value?

Can I use Numeric Rangle parameter for this?

[audreygerred · Accepted solution]

Hello - this sounds like something you could use a what-if parameter for: 

What if Analysis in Power BI (Multi-layered Scenar... - Microsoft Fabric Community

Getting Started With The "What If" Parameter In Power BI | Enterprise DNA

'What If' Analysis Techniques For Power BI - Microsoft Fabric Community

[Anonymous · Accepted solution]

Hi @Anonymous ,

As @audreygerred  said, we can create a numeric range of parameter.

Since the calculated columns do not have access to the parameter values, we need to create a measure.

Proposed ARR = MAX('Table'[ARR]) * (1+SELECTEDVALUE(Parameter[Parameter]))

Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[audreygerred · Accepted solution]

Hello - this sounds like something you could use a what-if parameter for: 

What if Analysis in Power BI (Multi-layered Scenar... - Microsoft Fabric Community

Getting Started With The "What If" Parameter In Power BI | Enterprise DNA

'What If' Analysis Techniques For Power BI - Microsoft Fabric Community