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...
Hi,
Thank you for your message, and please share your sample pbix file's link, and then I can try to look into it.
Hello Jihwan,
Thank you so much for reply.
Please see below with my dummy dataset and screenshot.
Basically, I like to create a measure or dax to be able to take the most recent supplier invenotry QOH from row 11 + row 12 forecast production - row 12 baseline = row 12 supplier inventory. Row 13 supplier inventory qoh = row 12 supplier invneoty 923,607(from calculation above)+ 72000-17933. and the sequence continues to the alst row.https://drive.google.com/file/d/1nSIRnbtyE_AwmjD9C2EBWanVzyuUD4Ot/view?usp=sharing