DAX Date & Time - MINUTE function



Description

Returns the minute as an integer from 0 to 59.

Syntax

MINUTE (<datetime>) 

Parameters

Sr.No. Parameter & Description
1

datetime

A datetime value representing time. E.g. 18:15:00 or 6:48 P.M.

Return Value

An integer from 0 to 59.

Remarks

The argument to the MINUTE function is the time that contains the minute you want to find.

You can specify the time as one of the following −

  • Output of a date/time function.
  • An expression that returns a datetime.
  • A value in one of the accepted time formats.
  • An accepted text representation of a time.

The MINUTE 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. Review your locale settings to understand your results.

Example

= MINUTE ("18:15:15") returns 15. 
= MINUTE ("6:25:15")” returns 25. 
= MINUTE (Now ()) returns 11 if Now () returns 12/16/2016 9:11:00 AM. 
dax_functions_date_time.htm
Advertisements