Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
TestTime | TestTime3h |
11/10/2019 6:00AM | 11/10/2019 6:00AM |
11/10/2019 8:00AM | 11/10/2019 9:00AM |
My requirement is to group fields for every 3 hours ,I am trying to use the below DAX formula
Formula for TestTime3h = MROUND(JSAutomation_loading_temp[TestTime], TIME(3,0,0)) + TIME(0,0,0). But I need 6-9 as 6 AM block. Please let me know.
Do you have a calendar table ? You might have an "Hours" table that had one entry for every hour in the day. Then a column that listed the "hour block". You could link that table to the TestTime and it would automatically give you the "hour block" by using the relationship.
Help when you know. Ask when you don't!
@kentyler thanks for the quick reply, yes i have rounding to 1hr in my data but i wanted to group my date to every 3 hours
meaning 12am-3am,3am-6am so on.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |