Trying to Find Difference Between Two Times in Minutes

[AshlerK]

Hope I can make this clear, am a somewhat intermediate user, can make DAX formulas work after some trial and error. Need some assistance on a formula to calculate a difference in minutes between two calculated columns that are both from different tables.

Each column was calculated for it's own table so that I could find the average of lateminutes per vehicle_name category. This was to discover lateness in minutes at two different locations and then find the difference to learn the gained lateness from location 1 and 3. I have the two calculated columns doing exactly what I need for each table, and they display properly on the visual matrix.

Now I need to add a way to visualize the difference betweeb both columns when organized per vehicle_name. 

To help with the visual, vehicles come down the line reducing the location checkpoints until they hit LOC1. Trying to figure out difference in lateness for when it hits LOC3 and then continues travel to LOC1

Calculated Column formulas look like this per table:

Location 1 Table Calculated Column: 

LOC1 AVG LateMinutes = CALCULATE (AVERAGE ('LOC1 Vehicle Lateness'[LateMinutes]), ALLEXCEPT ('LOC1 Vehicle Lateness', 'LOC1 Vehicle Lateness'[VEHICLE_NAME]))

Location 3 Table Calculated Column:

LOC3 AVG LateMinutes = CALCULATE (AVERAGE ('LOC3 Vehicle Lateness'[LateMinutes]), ALLEXCEPT('LOC3 Vehicle Lateness','LOC3 Vehicle Lateness'[VEHICLE_NAME]))

[rohit_singh]

Create a calculated table as shown above. Add a calculated column that computes the difference between LOC1 and LOC3

[AshlerK]

Hello! Thank you for your time! This formula you have written for the calculated tbale is giving me an error. Specifically, it isn't retrieving the LOC3 AVG LateMinutes column from the second table. I am unsure why, it is able to pull all the data from the first table, but not the table I imported for LOC3. 

To give additional detail, even when I form a UNION between the two tables, the CP3 column does not show. I am unsure why. Perhaps because it is such a similiar formula that when combined they are viewing the same data?

[rohit_singh]

Please make sure there is an active relationship between the two tables similar to below

[AshlerK]

I have assured they are tied by their Vehicle_Name as well! I edited my above reply, the issue seems to be, in my calculated table, the LOC1 and LOC3 columns combine into 1 column. 

[rohit_singh · Accepted solution]

In that case try assigning column names while creating the calculated table

If that still doesn't work could you please share the sample data?

[AshlerK]

I appreciate the help and "hand-holding" immensely. Thank you very much, it works!