Forum Discussion
Previous Week Inventory - this week Sales
Hello, I like to create a new dax column based on previous week inventory - this week sales and be able to predict for the future. First, there is no inventory data value past the current week so i...
Hello Jihwan_Kim,
Thanks. I think we are getting close. Instead of the first date you have inventory, I want the start inventory is based on the week of today. I have week indexing for my date table so I like to pin the start inventory is max(week index) = week index(today()). And I don't have next week inventory that will be this week invnetory - this week sales( I know I say next week but this week will work as well).
Thanks!
Below is a screenshot of my dataset. supplier inventory QOH row 53 = supplier inventory QOH row 52 + forecasted prodcution row 53 - baseline row 53.
supplier inventory QOH row 54 = supplier inventory QOH row 53 + forecasted prodcution row 54- baseline row 54.