topic Re: Grouping Time in a DAX - in DAX Commands and Tips

Grouping Time in a DAX -

sharpedogs — Mon, 09 Mar 2020 15:52:33 GMT

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

Re: Grouping Time in a DAX -

Anonymous — Tue, 10 Mar 2020 11:20:31 GMT

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

Re: Grouping Time in a DAX -

Anonymous — Tue, 10 Mar 2020 11:35:00 GMT

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.