I just love how youve been able to do time series forecasting with DAX. Just amazing!! Is it possible to share the pbix file or just the sales data on your blog just to follow along
Hey New Subscriber to you with your Amazing Lesson on Forecasting.. And could you please make a video on IMPORTANT DAX Calculations & SQL Quick tips for Preparing Data Analyst interview Thank you!
Hey and thans a lot for this amazing feature Great success to have a seasonal forecast at month level When displaying it on a graph for 2024 it is perfect (with mensual datas from january 2022 as inputs) Unfortunately, i want to project the forecast cumulative sum at end of 2024 but it doesnt work with classical function as SUMX because it made some mistakes with forecasted measures Do you have a solution for this ?
That was added so that the trend starts where the actuals end, otherwise it starts with period one again, that was the error that i noticed during editing of the video
Very nice, but I am not able to get this working. In the Measure "Sales Forecast - Trend" from your Blog, i get the message: Can not find name [Slope1]. Any idea? Where is this defined? Thanks in advance!
this video generated a ton of questions, I tried to answer them all in this video: ruclips.net/video/fTv1VJRuHMg/видео.html
Outstanding content. Keep going please.
Thank you! If you have any good topics that you would like us to cover, please let us know
I just love how youve been able to do time series forecasting with DAX. Just amazing!!
Is it possible to share the pbix file or just the sales data on your blog just to follow along
I will have to build something from scratch, unfortunately, i can't share the file I used as it has sensitive data
Hey New Subscriber to you with your Amazing Lesson on Forecasting.. And could you please make a video on IMPORTANT DAX Calculations & SQL Quick tips
for Preparing Data Analyst interview
Thank you!
And Forgot to say You really blink less number of times in the complete video
excellent
Ty!
Hey and thans a lot for this amazing feature
Great success to have a seasonal forecast at month level
When displaying it on a graph for 2024 it is perfect (with mensual datas from january 2022 as inputs)
Unfortunately, i want to project the forecast cumulative sum at end of 2024 but it doesnt work with classical function as SUMX because it made some mistakes with forecasted measures
Do you have a solution for this ?
Great lesson.On your blog, you added the WeeksCount to the Trend forecast calculation. What's the reason if I should ask
That was added so that the trend starts where the actuals end, otherwise it starts with period one again, that was the error that i noticed during editing of the video
Very nice, but I am not able to get this working. In the Measure "Sales Forecast - Trend" from your Blog, i get the message: Can not find name [Slope1]. Any idea? Where is this defined? Thanks in advance!
I am going through every step of this calc in this follow up video: ruclips.net/video/fTv1VJRuHMg/видео.html
Could you provide the R coding as well I want to try and do both to see how well mine turned ?
i have the link to the code and some background to it i this video description: ruclips.net/video/fTv1VJRuHMg/видео.html