Forum Discussion
Calculated Column based on Condition.
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?
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
- Anonymous2 years ago
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.
2 Replies
- audreygerredSuper User
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
- AnonymousNot applicable
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.