Forum Discussion

Grevatious's avatar
Grevatious
Frequent Visitor
6 years ago
Solved

Get the last delivery date

Hello everyone,   I need some help! I have two tables. The first one has all of the order description and client information and the other shows all the information regarding the delivery of each o...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Grevatious ,

     

    Would you please refer to the following measure:

    last delivery date =

CALCULATE (

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

    ALL ( 'Delivery Information' ),

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

)

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

     

    Best Regards,

    Dedmon Dai

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Probably in Table1,

 

Last delivery date = MAXX(FILTER(RELATEDTABLE('Table2'),'Table2'[Order]=[Order]),[Delivery date])