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

= MINUTE(
     <datetime>
)

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

Related Support Forum Posts

Median Of A Time Column
Developing Complex Dax functions
Getting started with DAX: DAX function types

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.

= MINUTE (
    Order[TransactionTime]
)

Example 2

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

= MINUTE (
    “February 12, 2020 2:00 PM”
)

Related DAX Functions

HOUR
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