Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Forecast by month aggregate to year problem

In a Power BI forecast report I would like to make a forecast based on data of previous years   These are my steps so far:   In 3 base measures I calculate a percentage by period:  % Actual Sa...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may use a similar way as shown here.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Anonymous,

 

You may use a similar way as shown here.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    v-chuncz-msft, Thank you for your reply, I am having trouble to translate the suggested solution to my situation

    Could you please give me another suggestion?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    v-chuncz-msft: Figured it out!  Thank you.

     

    It works with an extra measure on top of the Forecast measure

    Aggregatable Forecast=
SUMX (
    SUMMARIZE ( Transactions, 'Calendar - Transactiondate'[MonthNr] ),
    [Forecast]
)