Difference between minimum times of two bases

[Syndicate_Admin]

Good morning

I need to know how to get the time difference between the minimum value of one table with the minimum value of another according to its operator, however these tables have different times I don't know if anyone could support me

For example, for day 8/06 I need to find the value between 9:10 (table 1) and 9:35:58 (table 2), for each Client, on each of the days in order to get a total average of this value

I would greatly appreciate your support

[elitesmitpatel]

hi @Syndicate_Admin 
For Table1:

MinTime_Table1 =
CALCULATE(
MIN(Table1[TimeColumn]),
FILTER(Table1, Table1[Operator] = "SpecificOperator")
)

For Table2:

MinTime_Table2 =
CALCULATE(
MIN(Table2[TimeColumn]),
FILTER(Table2, Table2[Operator] = "SpecificOperator")
)

A measure to calculate the time difference between the minimum values from the two tables.

TimeDifference =
DATEDIFF(
[MinTime_Table1],
[MinTime_Table2],
SECOND
)

[Syndicate_Admin]

Thanks a lot! But I don't think I knew how to express myself, what I require is the average of that time among all the clients and although in the example I put 3 really there are more than 200, I don't know if you would have any solution for this?

[elitesmitpatel · Accepted solution]

Hi @Syndicate_Admin 
please refer the link I have made a realtionship and then the output difference were in seconds
Difference between minimum times of two bases solution 

If you get help then Please Accept as Solution