Show events between times / creating timeslots

[EgbertMellema]

Hi,

I'm working in a datase with telephone info. In that database there is 1 column with the starttime of the call. There is no column with endtime.
Ik want to create a measure, or a new column with timeslots; so I can calculate how many calls there are between
8:30 -11:00,
11:00 - 13:30,
13:30 - 16:00,
16:00 and 17:30

Does anybody have a solution for this?

Many thanks in advance....

Egbert

[mhossain · Accepted solution]

@EgbertMellema 

In addition to @amitchandak example, try attached pbix with mapping table approach, where you can control your timeslot and sort accordingly.

Let me know if this is what you were looking for.

[EgbertMellema]

Thanks! This is exactly what I was looking for. Help is very much appreciated!

[amitchandak]

@EgbertMellema , Create a new column like

new column =
var _time = time(hour([col1]),minute([col1]),second([col1]))
return
switch(true () ,
_time >= time(8,0,0) && _time <= time(11,0,0), " 8:30 -11:00" ,
_time > time(11,0,0) && _time <= time(13,30,0), " 11:00 - 13:30" ,
/// add other
"16:00 and 17:30" //default
)