Returns the hour as an integer from 0 (12:00 A.M.) to 23 (11:00 P.M.).
|Sr.No.||Parameter & Description|
A datetime value representing time. E.g. 18:15:00 or 6:48 P.M.
An integer from 0 to 23.
The parameter to the DAX HOUR function is the time that contains the hour you want to find.
You can specify the time as one of the following −
The HOUR function uses the locale and date/time settings of the client computer to understand the text value in order to perform the conversion. Most locales use the colon (:) as the time separator and any input text using colons as time separators will parse correctly. Review your locale settings to understand your results.
= HOUR ("18:15:15") returns 18. = HOUR ("6:15:15") returns 6. = HOUR (NOW ()) returns 9, if NOW () returns 12/16/2016 9:02:12 AM.
26 Lectures 4.5 hours