DAX Function Guide

MINUTE
Empty image or helper icon

Sam McKay

CEO & Founder

How does the MINUTE 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?

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

Loading

Considerations when using the MINUTE?

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

Loading

Formula examples using the MINUTE

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 Courses

Loading