Forum Discussion

heiligbd's avatar
heiligbd
Helper I
3 years ago
Solved

Material Requirements Planning Bucket By Date/Week

Good day,   I am working on material requirements planning for a complex capital intensive product with significant variability in requested finished good product. I have a table of sales orders by...
Interesting Links
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Please download the PBI file.  In the Calendar Table, write a calculated column formula to calculate week number and drag that week number column to the visual.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

For B123 and B456, shouldn't the answer be 5 for week 2?  If my understanding is correct, then share a Calendar table with a week number column.

heiligbd's avatar
heiligbd
Helper I
3 years ago

Yes, apologies,  I may have made a mistake in hast of trying to get this posted. However, I would like to have this in table format instead of matrix because of other things that need to added/addressed. Therefore, I am assuming that I am going to need a variable written of some sort for this MRP like function. Any help with that would be much appreciated!

 

Thanks, Bryant 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Please read the second sentence of my previous message.