Forum Discussion

Luxsta85's avatar
Luxsta85
New Member
2 years ago
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 ...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    Luxsta85 

    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
Luxsta85's avatar
Luxsta85
New Member
2 years ago

Hi Daniel29195,

 

Measure 2 seems to be the same as meaure 1

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

Luxsta85 

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