Power Query Question

[bnpendley]

I am new to Power BI., and I am lost at the moment.  I need to make this data show in a power bi report as an hour/building

I need to see the check-ins by the hour for each building.   I have grouped by building but still cannot figure out the best way to change the data to show by the hour for building?

Check In date	Check In Time	Building
7/15/2022		Ridgecrest North
7/15/2022		Presidential II
7/15/2022	10:58:00 AM	Presidential I
7/15/2022		Ridgecrest West
7/15/2022		Blount
7/15/2022		Paty
7/15/2022	10:57:00 AM	Presidential I
7/15/2022		Riverside West
7/18/2022	1:33:00 PM	East Edge Apartments
7/20/2022	11:00:00 AM	Bryant
7/20/2022	5:01:00 PM	Mary Burke West
7/20/2022	12:00:00 PM	Martha Parham East
7/20/2022	10:54:00 AM	Lakeside West
7/22/2022	9:38:00 AM	Tutwiler
7/22/2022	9:37:00 AM	Tutwiler
7/22/2022	9:35:00 AM	Tutwiler
7/22/2022	10:04:00 AM	Tutwiler
7/22/2022	10:12:00 AM	Tutwiler
7/22/2022	9:55:00 AM	Tutwiler
7/22/2022	10:20:00 AM	Tutwiler
7/22/2022	9:50:00 AM	Tutwiler
7/22/2022	10:24:00 AM	Tutwiler
7/22/2022	9:34:00 AM	Tutwiler
7/22/2022	10:22:00 AM	Tutwiler
7/22/2022	9:49:00 AM	Tutwiler
7/22/2022	9:28:00 AM	Blount
7/22/2022	10:16:00 AM	Tutwiler
7/22/2022	9:26:00 AM	Blount
7/22/2022	10:00:00 AM	Tutwiler
7/22/2022	9:43:00 AM	Tutwiler
7/22/2022	9:41:00 AM	Tutwiler
7/23/2022	1:00:00 AM	Ridgecrest North
7/23/2022		Presidential II
7/23/2022	1:30:00 PM	John England Jr.
7/23/2022	8:00:00 PM	Mary Burke East
7/23/2022		Bryce Lawn
7/24/2022	6:00:00 PM	John England Jr.
7/24/2022		Presidential I
7/25/2022		Bryce Lawn

[Greg_Deckler · Accepted solution]

@bnpendley You could create a new custom column using Time.Hour and then group by date and hour?