New column based on MAX[Date] in other column

[jdevalk77]

I have 3 tables, [resource] -> [timesheet] -> [project]

Resource table:

ID	Resource
1	Paul
2	Frank

Timesheet table:

ResourceID	ProjectID	Date
1	6	27.11.2023
2	7	27.11.2023
1	8	28.11.2023
2	9	28.11.2023

Project table:

ID	ProjectName
6	SE blablabla
7	TE blablabla
8	UE blablabla
9	VE blablabla

Now I'd like to add a column to the reource table with the left 2 characters of the latest ProjectName they've worked on. So in case of Paul, it would result in "UE" and in case of Frank it would result in "VE"
Can anyone help me with the column DAX formula?

[jdevalk77]

It's not working as it is not the MAX[projectname]. It should be the projectname where they worked on the latest.

Anyone?

[Ahmedx]

which is not what was asked, I did it.
if you need the full name of the project, just write it like this

[Ahmedx · Accepted solution]

pls try