Grouping Time in a DAX -

[sharpedogs]

Hi, 

I get fed new reports every hour and for activity that takes place every 5 miniutes. I want to be able to gorup the times together in a Matrix so that I show the Max Qty in 2 hour chunks. 5 minute intrivlas is to much.

I want a DAx so that it recognizes everyting between the time 12:00:00 am and 2:00:00am as it's own block. 

User	# of logins	Day	Time
Chad	4	March 6	12:05:00am
Dave	5	March 6	12:10:00am
Sam	6	March 6	1:15:00am

[Anonymous]

Hi @sharpedogs 

Click on column and filter column by greater than and less than values.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

I would do that in Power Query. Shaping data for analysis, and this is what you're talking about here, should be performed in PQ. DAX is a Data Analysis Expressions language, not a data mashup engine.

Best
D