TIME DAX Function

The TIME DAX function converts hours, minutes, and seconds given as numbers to a time in datetime format.

DAX Syntax TIME(hour, minute, second)

The function has the following parameters:

Example: Let’s create a measure.

DAX

Time Measure = TIME(14, 30, 0)

This returns: 2:30 PM
The output of the above dax code is shown below:

TIME dax function

Use Case: When we have separate columns like Hour, Minute, and Second, and we want to combine them into one Time column.