DATEDIFF measure Between two tables that are linked to one table

[comacabana]

Hi all,

I've come across an issue calculating the datediff between two tables. These two tables aren't connected to each other but rather to another table. To make it easier I'll add a screenshot below. I'd like to calculate the datediff between the quotation closed date in the quotations table and the actual start date in the work orders table. Both quotations and work order is linked to the case table.

Would what I want be feasible to do in a measure? 

Thank you and I appreciate your help as always

 

[FreemanZ]

hi @comacabana 

how are they related to the case table?

[comacabana]

The common field between all tables is the CaseID, not sure if this answers your question? So it's a one to many relationship from CaseID in Cases table to CaseID in the quotations table and it's the same case for the work order table