LAST DATE WITH SALE BY CUSTOMER

[CESARPULIDOGDL]

Hi!

I have a situation, i hope anybody could help me.  

I have 2 tables, table A kardex customers. And table B sales by date and customer's.

tableA.

Table B.

I need a measure or calculated column in table A, that showme the last date of sales of that customer, like green column:

thank you.

[Mahesh0016]

@CESARPULIDOGDL  
create Calculated Column in Table A =
last Date = MAX(realated('Table B'[Date]))

@CESARPULIDOGDL I hope this help you.

[CESARPULIDOGDL]

it doesn't work, anyway, thanks.

[FreemanZ]

hi @CESARPULIDOGDL 

Supposing they are related, try to add a calculated column like:

Column =

MAXX(

   RELATEDTABLE(TableB),

   TableB[last date  sales]

)