In PowerBI I have sales data from the past years until today.
What I need:
- Forecast for current year, taking in account YTD and the seasonality from the last years
- Forecast for next years
- Summation per year
(1) and (2) are easy to achieve with the build-in functionality of PowerBI forecasting assuming I have complete dates and the sales data.
I now would suppose using the drill-up-function of the widget, I’d get the correct values, however it does not contain any data from today to end of year, because it does not summarize real and predicted values.
Is there any possibility to achieve this?
Anyone have an idea how to achieve this with DAX formulas?
You may find a demo with sample-data in the following PowerBI file:
https://drive.google.com/file/d/1MDyMG2Vz4bVdhg_VcNQAhnR3nHs0FCSg/view?usp=sharing
2