Forum Discussion
How to average hourly events
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
Community ChampionAnonymous - 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.
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 Follow: