Reply
dapm11
Frequent Visitor

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.

 

OrderFulfilment.JPG

 

 

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

ProductQty OrderedDay
AAA-BBB-CCC4730
AAA-BBB-CCC243
AAA-BBB-CCC234
AAA-BBB-CCC244
AAA-BBB-CCC247

Table 2 

ProductQty 
AAA-BBB-CCC122
AAA-BBB-CCC267
AAA-BBB-CCC30
AAA-BBB-CCC25
AAA-BBB-CCC57
  501 

 

And this is the Matrix I'm trying to recreate

Product QtyAllocation 
Day 0Day 1Day 2Day 3Day 4Day 5Day 6Day 7Day 8Day 9Day 10Day 11Day 12Day 13Day 14Total
AAA-BBB-CCC501473002440000000000501

 

 

Thank you.

1 REPLY 1
lbendlin
Super User
Super User

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...

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)