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() function is not working for me.

Can anyone please help me with a way to get this to work.

 

As you can see in the image IDs match in both tables. I want submissiondate

 

Thanks!

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)

1 Reply

  • 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)