Last Delivered Date

[PowerBIIE]

Hi,

I need to create a report that shows what has been delivered filtered by date, which is easy but it does not show what has not been delivered as it does not have a date. So I need to create a calculated column, I saw that another post has this measure which is great but it's not what im looking for as if I use this in a column it retrieves the last date of the last order for all orders. 

last delivery date =

CALCULATE (

    MAX ( 'Delivery Information'[Delivery Date] ),

    ALL ( 'Delivery Information' ),

    'Delivery Information'[Order] IN DISTINCT ( Orders[Order] )

)

I have two tables, one called Orders with the order number, Order Qty and Ship Qty and another called OrderReceive with the Order Number, Ship Qty and Date Received.

I have merged the date from OrderReceive to Orders.

I need a calculated column for the last delivery date. Can anyone help me?

[Icey]

Hi @PowerBIIE ,

Have you tried to use RELATED() function like below to create a calculated column in table "Orders"?

Related Date Received =
RELATED ( 'OrderReceive'[Date Received] )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PowerBIIE]

No that is not what I am looking for

[PowerBIIE]

When I say the stuff not delivered, I am talking about partial deliveries, orders that have not been fully fulfilled

[calerof]

Hi @PowerBIIE ,

If you use the calculated column shown by @Greg_Deckler in this post you can have the orders pending:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Need-to-Match-Quantities-Supplied-vs-Ordered/... 

And it will look like this:

The code is:

Full Order = 
VAR __SuppliedQuantity =    
SUMX(
    FILTER(
         Table_Order,
         Table_Order[Order Number] = EARLIER(Table_Order[Order Number])
    ),
    Table_Order[Ship Quantity]
)
RETURN
  IF( Table_Order[Order Quantity] = __SuppliedQuantity,1,0)

If this is what you were looking for, please accept it as a solution.

Regards,

Fernando