Recognize peak entry times

[maheshwarineha]

How to find the peak time from a datetime column and show it in visual.

Sample data:

entry time
02-01-2023 00:58:36
04-01-2023 09:12:41
04-01-2023 19:36:58
04-01-2023 18:08:24
04-01-2023 12:47:17
04-01-2023 19:06:20
07-01-2023 01:13:52
07-01-2023 05:28:54
07-01-2023 18:09:17
07-01-2023 00:13:20
07-01-2023 09:55:14
08-01-2023 13:39:52
08-01-2023 19:35:27
08-01-2023 04:56:45
08-01-2023 10:58:22
08-01-2023 01:00:01
09-01-2023 14:16:59
09-01-2023 15:09:10
09-01-2023 14:10:12
09-01-2023 17:25:30
09-01-2023 18:55:21
09-01-2023 11:56:11

[Anonymous · Accepted solution]

Hi @maheshwarineha ,

I create a table as you mentioned.

Then I create two calculated columns.

Hour = HOUR('Table'[entry time]) 

Entries =
COUNTROWS (
    FILTER ( 'Table', HOUR ( 'Table'[entry time] ) = EARLIER ( 'Table'[Hour] ) )
)

Finally I put it into the visual and it will give you the result.

Best Regards

Yilong Zhou

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

[MFelix]

Hi @maheshwarineha 

Use the MAX formula to get the maximum value that you need.