Start time and End time

Hi Anonymous  ,

I think you want something like this.

Create a Time interval table by the expression below. Interval time is 30 min

Time = GENERATESERIES(TIME(0,0,0),TIME(23,59,59),TIME(0,30,0))

Creat a measure like the following:

Measure =
COUNTROWS (
    FILTER (
        'Table',
        TIMEVALUE ( [Start] ) < SELECTEDVALUE ( 'Time'[Start] )
            && TIMEVALUE ( [End] ) > SELECTEDVALUE ( 'Time'[End] )
    )
)

The final reault:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.