Time Power Bi Query

[bdehning]

I have the following Custom Column

Time.From(if Number.Round( Number.From( [Time of Incident] ) * 24.01 ) / 24=1 then 0.0 else Number.Round( Number.From( [Time of Incident] ) * 24.01 ) / 24)

This provides me the following.  

  How do I change it or what do I need to do to create 2 hour time frame counts like:

Blank

00:00 - 02:00

02:00 - 04:00

04:00 - 06:00, etc.

Any time :30 or greater goes up and lower than :30 goes down.   

[bdehning · Accepted solution]

Thanks, I was able to create a conditional column for all time frames and then created a sort Custom column to be able to sort in the order I wanted.  

[Daryl-Lynch-Bzy]

Hi @bdehning - you could consider adding Time Dimension table similar to calculate.  This will give you the ability to add multiple Time Bands.  Here is good time dimension table.  Time Dimension Table via Power Query – Insight Quest (insightsquest.com) from @Brettp761