Relative Content

Tag Archive for powerbipowerquery

Allocation model in Power query

I want to create a simple allocation model in power query which will allocate inbound inventory to open orders. I have 2 tables as shown below. The first table is showing the open orders by SKU and then second table is showing inbound inventory by SKU which are going to available to allocate on multiple dates.
The final result would be a table that shows allocated units for each SKU and the dates on which they got fully allocated. If it is not fully allocated then the last date of allocation to be available.