Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need help calculating time difference between two dates in different tables using the relationship

Hello Guys,   I have one problem where I want to calculate time difference for two date columns.   Problem is that both the columns are in different tables and for some odd reason Related() funct...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Check out tables 9 and 10 of the attached file.

     

    Difference = DATEDIFF(MAXX(FILTER('Table10','Table10'[ImageID]=Table9[ImageID]),[SubmissionDate]),[Created],DAY)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Check out tables 9 and 10 of the attached file.

 

Difference = DATEDIFF(MAXX(FILTER('Table10','Table10'[ImageID]=Table9[ImageID]),[SubmissionDate]),[Created],DAY)