Display cumulative no. of sessions versus time period - start time to end time

[rohitthb]

Hi,

I am struggling to find a way of showing during what time period are the busiest for an employees. The data is available at employee session level - where for each employee we get a start time and an end time. If of any help, the time difference between starttime and endtime can be 10 mins, 15 mins, 30 mins, 45 mins, 60 mins or 90 mins.

I want to show between what hours is the employee busiest in a month - In a time range of 15 mins. 

10:00 AM row denoting that there were 10 sessions in a month when the employee was busy between 10:00 AM to 10:15 AM (Start time was less than or equal to 10:00 AM and end time was greater than or equal to 10:15 AM).

Been struggling to do this for quite some time. 

[Anonymous]

Thanks for sharing😉.

Paul Zheng _ Community Support Team

[rohitthb]

Got a solution here. Trying it out and will update. 

https://community.powerbi.com/t5/Desktop/Counting-numbers-per-hour-between-a-start-and-end-time/m-p/... 

[rohitthb · Accepted solution]

Created a new table of 15 mins slot called timeslot and then used the below mentioned measure which worked. Thanks to the post 

https://community.powerbi.com/t5/Desktop/Counting-numbers-per-hour-between-a-start-and-end-time/m-p/... 

Counter = CALCULATE(COUNT(ip_ahp_order[EpisodeNo]),FILTER(ip_ahp_order, ip_ahp_order[Orderstarttime] <= Min(timeslot[time]) && ip_ahp_order[Orderendtime] > MIN(timeslot[time])))