cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## Difference between minimum times of two bases

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

1 ACCEPTED SOLUTION
Resolver II

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

3 REPLIES 3
Resolver II

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
)

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?

Resolver II

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