Count the number of occurances in any give hour using DAX

[PAD]

How are you guys. I have a dataset where I want to count the numver of events happening in any given hour. The objective is to find the hour or period with many events. for example:

A table with date, hour and event columns. I would to pick the hour (between 00:00 & 23:59) which has a lot of activity regardless of the date. Below is a dataset screenshot

[v-jianboli-msft · Accepted solution]

Hi @PAD ,

Please try:

First create a parameter:

Then apply the measure:

Measure = CALCULATE(COUNT('Table'[Time]),FILTER('Table',HOUR([Time])=SELECTEDVALUE(Parameter[Parameter])))

Final output:

Best Regards,

Jianbo Li

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

[JorgePinho]

Hello @PAD !

You can create bins on the hour column. See this article: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning