The Power BI HOUR function is one of the DAX Date and Time functions used to extract and return the hour numbers from 0 (midnight) to 23 (11 PM)from the given DateTime. This article explains the POWER BI DAX HOUR function that accepts the datetime value and returns an integer from 0 to 23 and the syntax is shown below:
HOUR(<datetime>)
The HOUR function takes the time value as the argument and extracts the hour part from it. The argument can be a time, a combination of date and time, direct input of time, or the expression that returns the datetime. If you provide the text representation of the datetime as the argument, the DAX HOUR function uses the local computer date/time settings to read the value.
Power BI DAX HOUR function Example
To demonstrate the DAX HOUR() function, we use the HireDate column from the NewEmployee table that has 15 records. To extract the Hour for each row, we need a new column. So, go to the Modeling Tab, click the New Column button, and rename it as Hours to obtain hours from the hire date.
Next, please add the new Hours column to the table report. Please refer to the DateTime and the function article for the remaining Power BI methods. For more Charts >> Click Here.
Hours = HOUR(NewEmployee[HireDate])
You can create a bar chart to show the hourly sales (sum of the sales by the employees hired hours). To do so, place Hours in the X-Axxis and Sales on the Y-Axis. In real-time, if you replace the HireDate with OrderDate, you get which hour is performing great.