Forum Discussion

Grevatious's avatar
Grevatious
Frequent Visitor
6 years ago

Get the last delivery date

Hello everyone I need help! I have two tables. The first one has all the description of the order and the customer information and the other shows all the information related to the delivery of e...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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 )