Forum Discussion
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...
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.
Apologies, misunderstood. See below Date Table example.
| Date | Week # |
| 8/1/23 | 1 |
| 8/8/23 | 2 |
| 8/16/23 | 3 |
| 8/24/23 | 4 |