I have a model which I have attached to this question.
From the data model, I am to calculate in minutes:
The difference between Sale date (DateID) and Completion Date (CompletionDateID)
The difference between Sale date (DateID) and ReviewDateID (ReviewDateID)
The difference between Completion Date (CompletionDate ) and Review Date (ViewDateID)
I will have to add the date field to the Time from Time field for all relevant date field before arriving at the correct answer.
The issue is the model has this information from Date table and Time table which are joined by broken relationships and I am unable to use the USERELATIONSHIP without CALCULATE function.
I truly need your help with is.
SalesData_Correct.pbix (2.2 MB)