Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Syndicate_Admin
Administrator
Administrator

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 me5b2254cc-18a9-4833-a8c8-ed72a1ae0d14.jpg7fa3bf21-8b0e-4eb4-84b3-e76cdc69ef1a.jpg

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

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 

elitesmitpatel_0-1720677217638.png

If you get help then Please Accept as Solution

 

View solution in original post

3 REPLIES 3
elitesmitpatel
Resolver II
Resolver II

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
)

 

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?

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 

elitesmitpatel_0-1720677217638.png

If you get help then Please Accept as Solution

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.