MINUTE is a DAX function that returns the minute component from a datetime value, ranging from 0 to 59.
MINUTE( Datetime )| Argument | Properties | Description |
|---|---|---|
| Datetime | A datetime value or text in time format, such as 16:48:00 or 4:48:00 PM. |
An integer number from 0 to 59.
In contrast to Microsoft Excel, which stores dates and times in a serial numeric format, DAX uses a datetime data type for dates and times. You can provide the datetime value to the MINUTE function by referencing a column that stores dates and times, by using a date/time function, or by using an expression that returns a date and time.
When the datetime argument is a text representation of the date and time, the function uses the locale and date/time settings of the client computer to understand the text value in order to perform the conversion. Most locales use the colon (:) as the time separator and any input text using colons as time separators will parse correctly. Verify your locale settings to understand your results.
The following example returns the minute from the value stored in the TransactionTime column of the Orders table.
= MINUTE(Orders[TransactionTime])
The following example returns 45, which is the number of minutes in the time 1:45 PM.
= MINUTE("March 23, 2008 1:45 PM")
Other functions related to MINUTE are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy