Forum Discussion

comacabana's avatar
comacabana
Frequent Visitor
3 years ago

DATEDIFF measure Between two tables that are linked to one table

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

 

 

 

@Dax help
DATEDIFF
relatedtable

2 Replies

    • comacabana's avatar
      comacabana
      Frequent Visitor
      3 years ago

      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