I have created a sales forecast in Power BI via the built in forecast function. And this works great. However I would also like to have an accumulated sales forecast, to see the total forecast for the next year. Power BI dosent recognize that this is accumulate, as an example, it therefore overestimates Jan 2024 in the accumulated model compared to the regular sales model. Anybody who also have this issue, and figured out a solution, that dosent involve exporting the data from PBI first?
PBI dosent have many built in options for this problem.
In the below figures, green is actual sales and black is predicted sales.
