Forum Discussion
Weekly Forecast with DAX
I'm looking to get some help to try and forecast weekly data in the current year. Here's a screenshot of an example I'm looking to try and mimic in Power BI:
The 2019 year will be interchangeable depending on what year's worth of data the end user is wanting to use. But for this example, I'm looking to take the week-to-week % change in 2019 and use that moving forward for the remaining weeks of the current year. This Forecast with DAX post is similar to what I'm trying to do, but I'm trying to use a changing growth percentage rather than a static one.
2 Replies
Hi jkteebs ,
Please tell me how to find 63983 when there are only 91888 and %50.392, I don't understand the logic between the two when I calculate them as if they are not related.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The numbers in the "WK" column are the weeks of the year, with 1 being the first week of the year and 52 being the last week of the year. So you have the sales listed by each week of the corresponding year, and then you have the percentage change from the previous week. So in the example you highlighted, the 50.39% is the percentage change from WK01 to WK02, and the -30.37% is the percentage change from WK02 to WK03.
