Time by hour by date

Question

Not a real analytics guy, trying to find my way through PowerBI.

I've searched and searched and cannot find a solution for my needs, which is probably simple, but most posts on this subject strike me to be overly complicated. Please see the example below, I have a lot of reports (built in Excel) that are similar to the example. This example of a simple pivot table, I need to count exams completed by each hour of the day, and for each day.

I have a Date table built in PowerBI in addition to my data table, that has proven effective days, days of the week and month/year. My date format from by data table is in the format below. Please help!!

1/26/23 0:14

Count


	1-Jan	2-Jan	3-Jan	4-Jan	5-Jan	6-Jan	7-Jan	8-Jan	9-Jan
12 AM	15	23	26	20	16	24	20	22	18
1 AM	24	20	15	25	24	22	17	15	13
2 AM	19	8	15	18	22	14	11	17	20
3 AM	16	11	16	18	21	23	24	5	10
4 AM	8	15	12	18	17	13	8	18	6
5 AM	27	14	12	39	14	23	7	21	9
6 AM	53	47	44	21	12	19	53	55	48
7 AM	25	20	37	36	51	37	22	25	35
8 AM	23	38	37	43	28	63	22	28	38
9 AM	37	38	45	50	45	50	28	20	35
10 AM	48	45	69	55	67	69	37	25	66
11 AM	53	63	62	54	61	64	32	34	61
12 PM	30	41	75	69	64	71	30	38	79
1 PM	55	49	63	55	70	66	41	39	62
2 PM	45	33	54	61	50	58	38	28	86
3 PM	43	37	52	64	63	67	55	36	52
4 PM	28	36	57	79	56	53	39	35	67
5 PM	33	39	64	63	33	49	58	35	49
6 PM	33	27	43	45	54	50	25	34	51
7 PM	32	27	42	50	47	32	27	23	36
8 PM	22	36	37	38	45	46	38	26	37
9 PM	33	31	45	43	50	37	34	19	37
10 PM	17	33	38	21	42	34	26	14	45
11 PM	17	26	35	39	30	28	31	22	25

driskbr · Answer

Figured I should show some examples of what I've attempted. Thanks again.&nbsp;&nbsp;&nbsp;

Forum Discussion

Time by hour by date

1 Reply

Related content

Hour Calculation

Date/Time

Date / Time difference excluding weekends and factoring working hours

Time + 6 hours

groups date/hours