Start time and End time

[Anonymous]

Hi everyone,

I want to count item in mintute series, and i have to colum start time and end time.

Which means i can find how many item in 8:46-8:47, or 8:50-8:51.

How to write DAX to show this, please help me,thanks.

Brs,

Dora.

[v-chenwuz-msft · Accepted solution]

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.

[amitchandak]

@Anonymous , Based on what I got

A new column

datediff([Starttime],[endtime], minute)

[Anonymous]

Hi @amitchandak ,

I want to show the table like this,and time series change to one minute.

I take reference https://community.powerbi.com/t5/Desktop/Start-and-end-time/m-p/756870?msclkid=255ce3abc43e11ecac1bb... ,however it didn't work.

If you have any suggestion , please help me,thanks a lot.