How does the HOUR function (DAX) work?

The HOUR function returns the time from 0 (12:00 AM) to 23 (11:00 PM) as a number.

HOUR Formula Syntax

 HOUR (<datetime>)

How do you use the HOUR function?

The HOUR function takes as argument the time that contains the hour you want to find. You can supply the time by using a date/time function, an expression that returns a datetime, or by typing the value directly in one of the accepted time formats. Times can also be entered as any accepted text representation of a time.

Considerations when using the HOUR function

When the datetime argument is a text representation of the date and time, the 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.