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
Daniel29195
Community Champion
Community Champion
measure 1
Expected Del =
var ds = filter(
SUMMARIZE(
Purchase_Order_Line_Excel,
Purchase_Order_Line_Excel[ExpDate],
Purchase_Order_Line_Excel[Exp Date]
)
, Purchase_Order_Line_Excel[exp date] <> "Delivered" )
var res =
SELECTCOLUMNS(
index(
1,
ds,
ORDERBY(Purchase_Order_Line_Excel[ExpDate],ASC)
),Purchase_Order_Line_Excel[ExpDate])
return res
measur 2 :
Expected Del =
var ds = filter(
SUMMARIZE(
Purchase_Order_Line_Excel,
Purchase_Order_Line_Excel[ExpDate],
Purchase_Order_Line_Excel[Exp Date]
)
, Purchase_Order_Line_Excel[exp date] <> "Delivered" )
var res =
SELECTCOLUMNS(
index(
1,
ds,
ORDERBY(Purchase_Order_Line_Excel[ExpDate],ASC)
),Purchase_Order_Line_Excel[ExpDate])
return res
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
- Daniel29195
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