cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
uthall Regular Visitor
Regular Visitor

Re: Group record last 24hrs by hour

Great, ok, so lets go back to the basics

I have a table of values

1. Column Startdate (datetime) and Column Endate (datetime). 

2. Column CustomerName

The duration between StartDate and EndDate could be many hours, and cross days.

I want a table/graph showing total unique customer count per hour for the last 24 hrs, inlcuding the hours between StartDate and Endate where there is no unique record. So for a record where StartDate is 27/06/2019 2200 to 28/06/2019 0100 i want a value of 1 for 2200, 2300, 0000, and 0100. Obviously cumulative if more records for other customers span this period.

The previous measure was OK, however where the dates crossed days, it broke down as it only grouped by hour, and did not account for date. It aslo did not filter the last 24hrs.

Hoping this is clear?

 

 

 

 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 39 members 1,032 guests
Please welcome our newest community members: