Rounding of datetime to every 3 hours in a day Power BI

[harishuppala2]

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.

[kentyler]

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.

[harishuppala2]

@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.