Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |