HOUR Function (DAX)

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.

Related Blog Posts

create-a-table-in-power-bi
How-To-Harvest-Power-BI-Slicer-Selections-To-Use-Within-Other-Measures
Power-BI-WHAT-IF-Parameters

Related Support Forum Posts

Calculating working hours between 2 timestamps
Date time (up to hour) range filter
Time of Day Slicer

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.

Related Video Tutorials

Find-Weekday-Weekend-Day-Numbers-Within-Months-Advanced-DAX
EDNA TV-Create Date Table fast
EDNA TV-Averages per Day

Formula examples using the HOUR function

=HOUR('Orders'[TransactionTime])  
=HOUR("March 3, 2008 3:00 PM")

Related DAX Functions

Date and Time Functions
MINUTE
YEAR

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership