Create New Curve from Forecast

Question

I have created this really cool tool in excel where I can take whatever projections another department gives me (we'll call this the future "track") and I can update it to my liking.&nbsp;&nbsp;Our track is built out on a weekly basis, and I would like to be able to change one, or multiples weeks' without changing the total, meaning the other weeks would all split the difference between the change, and the original total number, evenly.&nbsp;For example:Track:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Proposed Change&nbsp; &nbsp; &nbsp; &nbsp;New TrackWeek 1- 100&nbsp; &nbsp; &nbsp; &nbsp; +50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;150Week 2- 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 75Week 3-100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75Total - 400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;400&nbsp;Is there any way that I could set this up in a more user friendly way in Power BI? I would like the user to be able to put in whatever changes they believe is necessary, and to be able to to see the original track vs the new proposed track on a line graph.&nbsp;&nbsp;Thank you!!!&nbsp;&nbsp;

v-chuncz-msft · Accepted Answer

Anonymous&nbsp;,
&nbsp;
You may try adding a calculated column.
Column =
IF (
    ISBLANK ( Table1[Proposed Change] ),
    Table1[Track]
        - DIVIDE (
            SUM ( Table1[Proposed Change] ),
            COUNTBLANK ( Table1[Proposed Change] )
        ),
    Table1[Track] + Table1[Proposed Change]
)

Forum Discussion

Create New Curve from Forecast

1 Reply

Related content

S - Curve

S-Curve Actual + Forecast

How to create the S curve in Design

Creating S-curve visual in Power BI

Forecasting with DAX