HOUR DAX Function

The HOUR DAX function extracts the hour part from a time or datetime value. It returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).

DAX Syntax HOUR(datetime)

The parameter datetime is a column containing datetime values.

Example: Let’s create the measure.

DAX

Hour Measure = HOUR(TIME(14, 30, 0))

The output of the above dax code is shown below:

HOUR dax function