Latest date across two tables using DAX

Hi SJHA ,
Try the below calculated measure:

Title Level Latest Date = 
CALCULATE(
    MAX(Usage[Latest Date]), 
    ALLEXCEPT(Project, Project[Project Title])
)

Here's the output:

 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

Hi SJHA ,
The measure I mentioned earlier would still work:

Can you change the relationship to below?

If relationship can't be shared, can you share the current relationship between these 3 tables please.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn