Forum Discussion

hwoehler's avatar
hwoehler
Icon for Helper I rankHelper I
6 years ago
Solved

growth rates

Hello everybody,

I hope somebody can help me: I have a table ("Table1") with values ​​"Value1" and the associated date. There is also a "DateTable", which is linked to Table1.

There is a What If parameter, between 0-300% ("WhatIf", currently set to 120). I've created a new measure that subtracts, for example, the 100% from the e.g. 120%, because the number should represent the gain (profit).
current

I want to see, as shown in the following image, that a second line (in Excel column „New Value1“) appears in the graph. Starting from the first value of the selected period, this new time series should increase from 0% to 20%. The daily growth rate thus always increases by a certain amount (DailyGrowth). In Excel I could already solve this, unfortunately not in Power Bi Desktop. I have attached both files here: https://we.tl/t-hEfPs16Ynh
desired Result

In summary: I want a line in the graph that goes up to the value that the user enters (in this case, 20%).

I would appreciate any help,

hwoehler


,excel 1 (start)excel 2 (end) 

For a better understandig of the excel sheet:
-> Value1 is Value1 in PowerBI
-> New Value1=Value1 + Value2

-> Value2 = Value1 * DailyGrowth 
-> Daily Growth = DailyGrowth Value * iteration           --> DailyGrowth Value: e.g. 0,83% (see PowerBI image)

2 Replies

  • hwoehler Hi there, solution is attached. You explained the problem very well. It was easy to follow what you are trying to achieve. Thanks for all the details. Cheers!!

    • hwoehler's avatar
      hwoehler
      Icon for Helper I rankHelper I

      Hi parry2k ,
      thank you very much for your time and help! It worked, this is amazing!!
      Regards, hwoehler