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
Related Support Forum 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
Formula examples using the MINUTE function
The following example returns the minute from the value stored in the TransactionTime column of the Orders table.
= MINUTE (
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
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.