Forum Discussion

sharpedogs's avatar
sharpedogs
Icon for Advocate II rankAdvocate II
6 years ago

Grouping Time in a DAX -

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 loginsDay Time
Chad4March 612:05:00am
Dave5March 612:10:00am
Sam6March 61:15:00am

  

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    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