How to average hourly events

[Anonymous]

Hello ladies and gentlemen, I need help, because I don't understand how to make my chart present the number of events per hour, I want it to appear regardless of the day

Follow the img : https://imgur.com/CK5va0w but in this example, it has events per day and not for a hour.

[Greg_Deckler]

@Anonymous - Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

I have two columns, the first is for events and the second is for date and time, I would like to know how I can list events by the hour, For example:

[Greg_Deckler]

@Anonymous - So what does your source data look like? As in provide examples of your source data. Like, does it look like this:

Event	Date
One	6/2/2020 11:09 AM
Two	6/2/2020 12:57 PM

[Anonymous]

Follow: 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create a measure as below:

Measure = 
CALCULATE (
    COUNT ( 'Events'[Datetime] ),
    FILTER (
         'Events',
        'Events'[DescEvento] = MAX ( 'Events'[DescEvento] )
            && YEAR ( 'Events'[Datetime] ) = YEAR( MAX ( 'Events'[Datetime] ) )
            && MONTH ( 'Events'[Datetime] ) = MONTH ( MAX ( 'Events'[Datetime] ) )
            && DAY ( 'Events'[Datetime] ) = DAY ( MAX ( 'Events'[Datetime] ) )
            && HOUR ( 'Events'[Datetime] ) = HOUR ( MAX ( 'Events'[Datetime] ) )
    )
)

Best Regards

Rena