- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Order Fulfillmernt Matrix - 14 day Quantities Due & Quantities Remaining Calculations
I'm hoping someone may be able to help with this quite complex (to me) process.
I have a matrix that details order quantities with quantities in stock. I'm wanting to perform this calculation over a 14 day period. I think the image I've created below helps to describe this problem.
My starting point was to perform some merging of the two tables in Power Query to possibly reduce the requirement of complex DAX coding, however i'm now wondering if a pure DAX solution is better?
Also worth noting this example only considers one product, the logic is required to be applied to all products from the catalogue.
I'm hoping I've explained my problem fully and someone can help to point me in the right direction.
Table 1
Product | Qty Ordered | Day |
AAA-BBB-CCC | 473 | 0 |
AAA-BBB-CCC | 24 | 3 |
AAA-BBB-CCC | 23 | 4 |
AAA-BBB-CCC | 24 | 4 |
AAA-BBB-CCC | 24 | 7 |
Table 2
Product | Qty | |
AAA-BBB-CCC | 122 | |
AAA-BBB-CCC | 267 | |
AAA-BBB-CCC | 30 | |
AAA-BBB-CCC | 25 | |
AAA-BBB-CCC | 57 | |
501 |
And this is the Matrix I'm trying to recreate
Product | Qty | Allocation | |||||||||||||||
Day 0 | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Total | ||
AAA-BBB-CCC | 501 | 473 | 0 | 0 | 24 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 501 |
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
10 | |
8 | |
8 | |
6 | |
5 |
User | Count |
---|---|
17 | |
14 | |
10 | |
9 | |
6 |