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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Grevatious ,

Use this measure in you table to display the date

 

 

Measure =
VAR __id = MAX( 'Table'[Orders] )
VAR __date = CALCULATE ( MAX( 'Table'[Delivery date] ), ALLSELECTED ( 'Table' ), 'Table'[Orders] = __id )
RETURN CALCULATE ( MAx ( 'Table'[Delivery date] ), VALUES ( 'Table'[Orders] ), 'Table'[Orders] = __id, 'Table'[Delivery date] = __date )