Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create New Curve from Forecast

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.    Our track i...
Need Help
Tips and Tricks
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous ,

     

    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]
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

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]
)