MINUTE Function (DAX)

How does the MINUTE function (DAX) work?

MINUTE function returns the minute, given the date and time value, as a number from 0 to 59.

MINUTE Formula Syntax


How do you use the MINUTE function?

Unlike Microsoft Excel, which stores dates and times in a serial numeric format, DAX uses dates and times with a datetime data type. The datetime value for the MINUTE function can be given by referencing a column that stores dates and times, using a date / time function, or using an expression that returns a date and time.

Related Blog Posts


Considerations when using the MINUTE function

When the datetime statement is a text representation of the date and time, the method uses the client computer’s locale and date / time settings to recognize the text meaning to make the conversion. Some locales use the colon (:) to translate correctly as the time separator and any input text use colons as time separators. To understand your results, check your locale settings.

Related Video Tutorials

Calculating Averages Per Transaction Using DAX in Power BI

Formula examples using the MINUTE function

Example 1

The following example returns the minute from the value stored in the TransactionTime column of the Orders table.


Example 2

The following example returns 45, which is the number of minutes in the time 1:45 PM.

    “February 12, 2020 2:00 PM”


Related DAX Functions


Related Course Modules