Forum Discussion
Solved
Showing the Recent Quantity
Hi, I'm having an issue showing the Quantity of stock due in on the Date it is due in. For example, we have a product 36965 which has 510 pieces due in on 14/03/24. However, on the Desktop board ...
my bad
Expected Qty = var ds = filter( SUMMARIZE( Purchase_Order_Line_Excel, Purchase_Order_Line_Excel[ExpDate], Purchase_Order_Line_Excel[Exp Date], Purchase_Order_Line_Excel[Quantity] ) , Purchase_Order_Line_Excel[exp date] <> "Delivered" ) var res = SELECTCOLUMNS( index( 1, ds, ORDERBY(Purchase_Order_Line_Excel[ExpDate],ASC) ),Purchase_Order_Line_Excel[Quantity]) return res
Absolute legend! That all worked a treat. Thank you very much!