topic DATEDIFF measure Between two tables that are linked to one table in DAX Commands and Tips

DATEDIFF measure Between two tables that are linked to one table

comacabana — Tue, 31 Jan 2023 10:54:26 GMT

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

Re: DATEDIFF measure Between two tables that are linked to one table

FreemanZ — Tue, 31 Jan 2023 10:58:01 GMT

hi comacabana

how are they related to the case table?

Re: DATEDIFF measure Between two tables that are linked to one table

comacabana — Tue, 31 Jan 2023 11:55:12 GMT

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