Most RecentNewestMost VotedMost ViewedInventory Update each request attribuiting status Hello, On Power BI I have a Inventory that have a lot of requests of the same Item and the same Date. For this reason I need to make an status telling me if that inventory will be anough or not for those requests For Now I just have the first Part: Deducting Qty from different location in sequence Hi, I am trying to find a code that would help me with the below logic. Any help is highly appreciated. Inputs: Jobs with quantities . Each job is sequenced based on a date. There are 4 inventory locations and they are prioritized based on consumption. Logic: Deducation from Location 1, if location1 reaches to 0 qty then deduct from location2 and if location2 reaches to 0 qty then location3....... until location4 and if location4 is empty then "Order" text once it reaches negative. Output: Clear or not clear If "Order" then short by how much in total. Table 1 Job Date Part Number Qty Required Clear? Short in Total 1 01-Jul-22 ABC 4 Clear 2 02-Jul-22 ABC 2 ORDER -1 3 03-Jul-22 DEF 5 Clear 4 04-Jul-22 GHI 1 Clear 5 05-Jul-22 DEF 3 ORDER -2 6 06-Jul-22 ABC 4 ORDER -5 Table 2 Part Number Location 1 Location 2 Location 3 Location 4 ABC 3 1 1 0 DEF 5 0 1 0 GHI 0 0 0 1 Thanks Solved
