Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Syndicate_Admin
Administrator
Administrator

Calculate the number of operators working at the same time in a period of time

‎01-23-2024 07:57 AM

I have to calculate the number of workers working on a machine at the same time. I have a column with the start time, another with the end time, I have another column with the worker code, and another column with the machine number. The only thing I have been able to get is the different number of workers who have worked throughout the day, but the result, which is 32, is not what I needed, since that is the total number of workers who have worked on the machine throughout the day. What I need to know is how many have worked at the most at the same time, but I can't figure it out. Would anyone know how to do it?

Thanks a lot

Message 1 of 4
227 Views
0
3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

‎01-23-2024 11:55 PM

and I need to know how many operators have coincided at the same time at most throughout the day 19/01/2024 on machine A2. Because there are operators who come in, come out, and come back in, but I need to count the maximum number of workers who have worked together, and not the total number of operators who have gone through this machine

Message 4 of 4
189 Views
0
Daniel29195
Super User
Super User

‎01-23-2024 09:33 AM

@Syndicate_Admin 

to know which machine worked at the same time, you duplicate the table . then crossjoin the orginal table with duplicatred one and filter where machine name = machine name . 

 

 

then you can use filter, to check base on the business logic, and comparing start times and end times  .

the result would be the machines that worked togther. 

 

 

 

 

exmaple : 
table1 

 

table2 ( duplicate of table1) 

 

 

 

calculated table = 

var datasource = 

filter(

crossjoin ( table1 , table2 ) 

,table1[machine_number] <> table2[machine_number]
)

 

var result = 

filter(
datasource , 

 

//  add the filters base on the business logic seperated by &&  or || ) 
)

 

return result 

 

 

NB :  && --  and condition , || or condition 

 

 

 

 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

 

 

 

Message 2 of 4
191 Views
0
Syndicate_Admin
Administrator
Administrator
In response to Daniel29195

‎01-23-2024 11:38 PM

Here's my chart:

DateMatchdayworkerHomeDayEndDayMachine
19/01/202401430201:57:46 PM5:00:21 PMA2
19/01/202460728359:48:12 AM9:58:57 AMA2
19/01/2024779139110:31:53 AM10:39:43 AMA2
19/01/202460726902:26:33 PM2:26:51 PMA2
19/01/202481578202:33:13 PM3:19:20 PMA2
19/01/202481578203:24:35 PM5:00:21 PMA2
19/01/202481579899:06:06 AM1:00:01 PMA2
19/01/202482841767:55:53 AM12:28:51 PMA2
19/01/202460726902:26:51 PM4:18:09 PMA2
19/01/202460726904:18:09 PM4:28:50 PMA2
19/01/202460726904:28:50 PM5:00:21 PMA2
19/01/2024636365910:23:44 AM1:00:01 PMA2
19/01/202401245601:57:46 PM5:00:21 PMA2
19/01/202463636597:57:16 AM10:13:18 AMA2
19/01/2024636365910:13:18 AM10:23:44 AMA2
19/01/202463636591:59:06 PM5:00:21 PMA2
19/01/202452275581:57:46 PM5:00:21 PMA2
19/01/202452275587:55:53 AM1:00:01 PMA2
19/01/202463725939:06:06 AM11:40:59 AMA2
19/01/202460715587:54:41 AM1:00:01 PMA2
19/01/202401244617:55:53 AM1:00:01 PMA2
19/01/202489969788:13:39 AM10:59:17 AMA2
19/01/202460346369:02:32 AM1:00:01 PMA2
19/01/202401245027:38:59 AM1:00:01 PMA2
19/01/202401245022:00:34 PM3:39:37 PMA2
19/01/202477914522:33:13 PM5:00:21 PMA2
19/01/2024815801012:28:51 PM1:00:01 PMA2
19/01/2024815801011:03:43 AM12:17:57 PMA2
19/01/202464166307:58:56 AM8:06:28 AMA2
19/01/202401244611:57:46 PM5:00:21 PMA2
19/01/202438006397:54:41 AM1:00:01 PMA2
19/01/202401246172:27:57 PM5:00:21 PMA2
19/01/202463636954:28:50 PM4:37:30 PMA2
19/01/202401245712:33:13 PM3:16:02 PMA2
19/01/202464166303:54:45 PM5:00:21 PMA2
19/01/202464166303:46:59 PM3:54:45 PMA2
19/01/202464166302:26:51 PM3:46:59 PMA2
19/01/202463636952:29:26 PM4:28:50 PMA2
19/01/202490220242:27:57 PM4:14:19 PMA2
19/01/202463636954:37:30 PM5:00:21 PMA2
19/01/202490220244:30:25 PM5:00:21 PMA2
19/01/202401245713:16:02 PM3:24:35 PMA2
19/01/202401245713:24:35 PM5:00:21 PMA2
19/01/2024637259311:40:59 AM11:55:41 AMA2

Message 3 of 4
189 Views
0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All