HOUR DAX Function (Date and Time)
Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
Syntax
Parameter | Attributes | Description |
---|---|---|
Datetime |
A datetime value or text in time format, such as 16:48:00 or 4:48:00 PM. |
Return values
An integer number from 0 to 23.
Examples
-- Extract time parts from a DateTime column EVALUATE ADDCOLUMNS ( TOPN ( 10, VALUES ( Sales[Order Time] ) ), "Hour", HOUR ( Sales[Order Time] ), "Minute", MINUTE ( Sales[Order Time] ), "Second", SECOND ( Sales[Order Time] ) )
Order Time | Hour | Minute | Second |
---|---|---|---|
01:14:19 | 1 | 14 | 19 |
02:14:19 | 2 | 14 | 19 |
03:14:19 | 3 | 14 | 19 |
04:14:19 | 4 | 14 | 19 |
06:14:19 | 6 | 14 | 19 |
07:14:19 | 7 | 14 | 19 |
08:14:19 | 8 | 14 | 19 |
09:14:19 | 9 | 14 | 19 |
11:14:19 | 11 | 14 | 19 |
12:14:19 | 12 | 14 | 19 |
Related functions
Other related functions are:
Last update: Oct 3, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/hour-function-dax