what if parameter to perform scenario analysis

[Anonymous]

Hi,

Can you please help me with the following table? I need to calculate present value =Value/(1 + growth rate)^Period. Growth rate is a parameter to allow scenario analysis.

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

According to your description ,you can follow these steps :

1.New a parameter what-if as below:

Please refer to this article for more details :

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

2.create measures as below:

Prevent value = 
var rate = 1+Parameter[Parameter Value]
var  Present_rate = rate^MAX('Table'[Period])
return sum('Table'[Value])/Present_rate

Here is a sample I made:

URL: https://wicren-my.sharepoint.com/:u:/g/personal/michael_wicren_onmicrosoft_com/EXA7D1JfmqpBjllTHBL18dQB3Q-6S4o4x1krcWkrZu0dzw?e=Qn0V5a

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

value =divide(sum(Value)/(1 + power((growth rate),sum(Period)))