Forum Discussion
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)
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!!