Forum Discussion
Subtracting Dates within Two Different Tables
I'm still getting the same error. The two tables are quite large but here is some of the important information:
| Table Field | Sample Data |
| SCCalls.EquipmentID | 12345 |
| SCCalls.CallNumber | 201123 |
| SCCalls.CallTypeID | P |
| SCCalls.CustomerID | 123 |
| SCCalls.CreateDate | 1/1/18 2:00pm |
| SCCalls.CloseDate | 1/5/18 5:00pm |
| Table Field | Sample Data |
| SCEquipments.EquipmentID | 12345 |
| SCEquipments.CustomerID | 123 |
| SCEquipments.CreateDate | 1/1/18 2:00pm |
| SCEquipments.InstallDate | 1/2/16 3:00pm |
Let me know if I need to give you more information.
Anonymous，
Right click your table and choose new measure, then apply my DAX. If you still get issues, please post expected result based on the sample data you share and post a screenshot about your current scenario.
Regards,
Lydia
I was wrong about the CallTypeID above. Apparently it's one of the few ID's that have numerical values instead of letters.
I put the measure in and got the below error.
I tried adding the Value function right before the (SCCAlls[CallTypeID]="55")) but I got this:
Thanks,
Anonymous,
What if the type of CallTypeID? If it is numerical type, change your DAX to the following:
Measure= CALCULATE(MAX(SCCalls[CreateDate]), FILTER(SCCalls, SCCalls[CallTypeID]=55))
Regards,
LydiaAnonymous,
Okay, this got the Measure to work correctly but now I have an error with the column. Can you take a look? You have been so helpful!!