Forum Discussion
Solved
Adding output previous week with a fixed "step" output
Hi! I am working on a forecast model where we need to predict future output based on history. What I have is a fixed "Step" output (which I calculated based on historical data). Lets say this ...
pls see if this is what you want
ryan_mayu I do have a date table connected to the fact table where the actual ouput is. So its a simple model with a date table connected to the fact table.
ryan_mayuSuper User
pls see if this is what you want
Thanks for your suggested solution, its definetly close. Problem is that I have ouput from from two years in my model (from mid 2023 until today). So the "week2" column gives incorrect week numbers with your calculation. Is there any way we can write a calculated week2 column which takes this into consideration?
- ryan_mayu
then when will the week start? Will we recalculate the week in the next year? could you pls update the sample data and provide the exepcted output?