Time.Hour
The hour, 0 to 23, of a time, datetime or datetimezone.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Time.Hour(dateTime as any) as nullable number| Parameter | Type | Description |
|---|---|---|
dateTime | any | A time, datetime or datetimezone value; null gives null. |
Returns
nullable number. The hour on a 24-hour clock.
Examples
The hour of an order
Time.Hour(#datetime(2024, 3, 15, 14, 30, 0))14Orders by hour of the day
let
Orders = #table(type table [Order = text, Placed = datetime], {{"A-101", #datetime(2024, 3, 15, 9, 5, 0)}, {"A-102", #datetime(2024, 3, 15, 14, 30, 0)}, {"A-103", #datetime(2024, 3, 15, 14, 55, 0)}})
in
Table.AddColumn(Orders, "Hour", each Time.Hour([Placed]), Int64.Type)| Order | Placed | Hour |
|---|---|---|
| A-101 | 2024-03-15 09:05:00 | 9 |
| A-102 | 2024-03-15 14:30:00 | 14 |
| A-103 | 2024-03-15 14:55:00 | 14 |