Forum Discussion
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...
v-chuncz-msft
Community Support
Community Supportv-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]
)