Get a value text to the last date by Id text

[ofeliajesus]

I have a table similar to the below one 

and I want a dax measure to give the last date description, the ID and Description are text. 

any help would be appreciated
Thank you

[tamerj1 · Accepted solution]

hi @ofeliajesus 
Please try
Last Description =
CALCULATE ( MAX ( TabeName[Description] ), TabeName[Date] = MAX ( TabeName[Date] ) )

[ofeliajesus]

Hi 

It works, 

but I believe is not optimised due to the fact that I have the error "Resources Exceeded This visual has exceeded the available resources." I need to pull data from 4 tables I think that is the reason.

I will create another post with another level of complexity.

Thank you