Formula Help

[erhan_79]

Hi there ;

ı need your support to create a column as below ;

i have two tables , Table A and Table B , Table A has only order numbers  and Table B has Order numbers and delivery dates.

Table A and Table B has relationship via Order Numbers.

i want to create a new colum in Table A named " Last Date " , and  rule will be like that : 

• write latest delivery date for an each order from Table B to Table A 

thanks in advance for your kind supports

[mahoneypat · Accepted solution]

You don't need to add an extra column to your model (it could be done with a measure).  But if you want to add the column, you can use this expression from your Table A.

LatestDelDate = CALCULATE(MAX(TableB[Delivery Dates]))

Pat