Forum Discussion

Volvo_Chang's avatar
Volvo_Chang
Helper I
2 years ago

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...
Volvo_Chang's avatar
Volvo_Chang
Helper I
2 years ago

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!

Volvo_Chang's avatar
Volvo_Chang
Helper I
2 years ago

Hello Jihwan_Kim ,

Just like to follow up on this one. Thanks!

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    Hi,

    Thank you for your message, and please share your sample pbix file's link, and then I can try to look into it.

    • Volvo_Chang's avatar
      Volvo_Chang
      Helper I
      2 years ago

      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