How to group by hours?

Hi Anonymous 

According to your statement, you want to count journeys between two whole datetime hour range. I think you can try to create a calculated table with RANGESTART and RANGEEND, then count journeys.

Firstly enter a time table from 0:00:00-23:00:00.

Then create a calculated table to show result.

DateTime = 
VAR _T1 =
    ADDCOLUMNS (
        CROSSJOIN ( CALENDAR ( DATE ( 2019, 01, 01 ), DATE ( 2019, 01, 01 ) ), 'Time' ),
        "RANGESTART", [Date] + [Time]
    )
VAR _T2 =
    SUMMARIZE (
        _T1,
        [Date],
        [RANGESTART],
        "RANGEND", [RANGESTART] + TIME ( 1, 0, 0 )
    )
VAR _RESULT =
    ADDCOLUMNS (
        _T2,
        "COUNT JOURNEYS",
            CALCULATE (
                COUNT ( 'Table'[ID] ),
                FILTER (
                    'Table',
                    AND (
                        'Table'[DateTime] >= EARLIER ( [RANGESTART] ),
                        'Table'[DateTime] < EARLIER ( [RANGEND] )
                    )
                )
            ) + 0
    )
RETURN
    _RESULT

Result is as below. Here I use the same data sample like yours. On 2019/01/01 between 13:00 and 14:00, we see that there were 8 journeys. 

You can download my sample file to get more details.

 

Best Regards,
Rico Zhou

 

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