Forum Discussion
Creating an PowerBI integrated forecast for calendar weeks
Hi guys!
Unfortunately my daily sales amount data is inconsistent, as why I wanted it to be aggregated on the level of calendar weeks in order to get the forecast work. Done. But the forecast option of the analysis toolbar only shows up for datatype date, but I couldn't find a good possibility to get my calendar weeks being in date format.
I may could link the sum of every week to one day to trick powerbi making it think its daily data. What I mean is 2019 1. cw -> 01.01.2000, 2019 2. cw -> 02.01.2000 and so on...
Maybe someone knows a better methode so that i can use the integrated forecast for my sales data.
sales table structure
| (date) sale day | (text) article | (number) price |
| 01.01.2019 | banana | 5 |
| 01.01.2019 | apple | 3 |
| 02.01.2019 | banana | 5 |
| 01.02.2019 | apple | 3 |
| 01.02.2019 | banana | 5 |
date table structure
| (date) dates | (text) year with cw |
| 01.01.2019 | 2019 1. cw |
| 02.01.2019 | 2019 1. cw |
| 01.02.2019 | 2019 5. cw |
Of course in reality there are many more datasets, but for the understanding how the basic structure is currently that should be enough.
I want to thank you all for help upfront!
Hi Anonymous ,
Please create a regular calendar table and drag the year and week fields into the visual x-axis.
The PBIX file is attached for reference.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
2 Replies
Hi Anonymous ,
Please create a regular calendar table and drag the year and week fields into the visual x-axis.
The PBIX file is attached for reference.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi Gao,
unfortunately this doesn't help because when I look at the weeks they are summed up for all years and not separated by year and week. I've got a solution to get a calculated column with year and calender weeks but this solution isn't really working because its no date format which is needed for integrated forecasting in powerbi.
Although thanks!