Forum Discussion

SJHA's avatar
SJHA
Icon for Helper I rankHelper I
3 years ago
Solved

Latest date across two tables using DAX

I have two tables: Project: [Project_title] [Project_module] A                     A A                     B A                     C B                     D B                     E C         ...
Need Help
  • Anand24's avatar
    Anand24
    3 years ago

    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
  • Anand24's avatar
    Anand24
    3 years ago

    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

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago
measure = 
MAXX( 
FILTER(AL('Usage'),
    'Usage'[Project_module]= max('Project'[Project_module]),[Latest_date]
)

----
Colum = 
MAXX( 
FILTER(AL('Usage'),
    'Usage'[Project_module]= 'Project'[Project_module],[Latest_date]
)